[GENERAL] Better way to handle functions doing inserts into dynamically named tables?

So, I wrote myself a trigger function that when called will dynamically create new partition tables and rules so that the first new record for each partition creates the partition. The only bit that I wanted to see if there was a a better solution was the actual insert into the new table at the en

Re: [GENERAL] What's the best way to index this table for speed?

;t work for you you still can possibly use a partial index if it works for your status_ids. -Steve Wormley Senior Consultant inCode Wireless a Verisign Company ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] insert performance riddle

> > Michael, you nailed it again. My libpq test C program delivered > between 2400 QPS and 5000 QPS vs ~10 QPS for DBI/DBD::Pg on this > box. > > It remains unclear to me why the same DBI/DBD::Pg client code > would deliver performance 2-3 orders of magnitude better on > other roughly comparabl