Friday, February 19. 2010

Part(ition)ing Is Such Sweet Sorrow

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" »

Posted by

David Fetter

at 04:21 | Comments (2) | Trackbacks (0)

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.

Posted by

David Fetter

at 09:32 | Comment (1) | Trackbacks (0)

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...

Posted by

David Fetter

at 07:10 | Comments (0) | Trackbacks (0)

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)" »

Posted by

David Fetter

at 03:04 | Comments (6) | Trackbacks (0)

(Page 1 of 1, totaling 4 entries)