[GENERAL] Problem with 8.1's pg_dump -- not dumping a partition

Hi, I just got an e-mail yesterday, regarding an issue with 8.1's pg_dump. The problem is: Even if they use pg_dumpall, PostgreSQL does not dump one of the partition, which is inherited by parent table. I don't have access to the machine, so I don't know what the exact problem is -- is this a kn

Re: [GENERAL] Changing FS when full

On 2010-01-21, Fernando Schapachnik wrote: > Hi, > > I have a big database on FS1, now almost full. Have space on FS2, > where I created a tablespace and moved every table and index to it. > Still, lots of space used on FS1. The problem is not pg_xlog, but > base: > > # du -hs base/105658651/*

[GENERAL] Ability to 'fork' a running transaction?

I'm writing a program which needs to do a lot of (read only) processing on a database. The program works on a SMP system with 16 CPUs, so it's natural to try to make it use all of them. However, here lies the problem: I need to use SERIALIZABLE transaction isolation level, and AFAIK it's not possi

Re: [GENERAL] Ability to 'fork' a running transaction?

On 31/01/2010 8:19 AM, Alex Besogonov wrote: I'm writing a program which needs to do a lot of (read only) processing on a database. The program works on a SMP system with 16 CPUs, so it's natural to try to make it use all of them. However, here lies the problem: I need to use SERIALIZABLE transa