> I’m having this very disturbing problem. I got a table with about
> 100,000 rows in it. Our software deletes the majority of these rows
> and then bulk loads another 100,000 rows into the same table. All this
> is happening within a single transaction. I then perform a simple
> “select count(*)
Josh,
On 7/20/07 4:26 PM, "Josh Berkus" <[EMAIL PROTECTED]> wrote:
> There are some specific tuning parameters you need for ZFS or performance
> is going to suck.
>
> http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide
> (scroll down to "PostgreSQL")
> http://www.sun.com/serv
Hello
did you vacuum?
It's good technique do vacuum table after remove bigger number of rows.
Regards
Pavel Stehule
2007/7/22, Jozsef Szalay <[EMAIL PROTECTED]>:
I'm having this very disturbing problem. I got a table with about 100,000
rows in it. Our software deletes the majority of thes
I'm having this very disturbing problem. I got a table with about
100,000 rows in it. Our software deletes the majority of these rows and
then bulk loads another 100,000 rows into the same table. All this is
happening within a single transaction. I then perform a simple "select
count(*) from ..." s
