There are excellent references on partitioning tables that depend on one table, but what happens when you need to partition the referenced table?
Let's find out!
Continue reading "Part(ition)ing Is Such Sweet Sorrow" »
Sunday, February 7. 2010
PostgreSQL Weekly News vs. Casa Donde
This week's PostgreSQL Weekly news may be rescheduled to Wednesday February 10, evening PST.
Thanks very much to whatever component failed at my home for this.
Thanks very much to whatever component failed at my home for this.
Friday, February 5. 2010
FOSDEM Starting
The herd of blue elephants is gathering for FOSDEM, including several talks in the main track.
I'd like to thank the FOSDEM for making it possible for me to attend this year.
More on this soon...
I'd like to thank the FOSDEM for making it possible for me to attend this year.
Monday, February 1. 2010
Adding Only New Rows (INSERT IGNORE, Done Right)
Let's say you have a table and a data set, and would like to add only those rows in your data set that aren't already in the table. There are hard ways, but here's an easy one.
Continue reading "Adding Only New Rows (INSERT IGNORE, Done Right)" »
(Page 1 of 1, totaling 4 entries)