Re: [PERFORM] How many Cluster database on a single server

2011-10-20 Thread d.davo...@mastertraining.it
Thanks everybody for the suggestions. Now I have a better idea on which direction proceed. When we will have some results we will post again to share. Thanks again! On 10/19/2011 05:13 PM, Kevin Grittner wrote: "d.davo...@mastertraining.it" wrote: We are thinking to use the Streaming Repli

Re: [PERFORM] Heavy contgnous load

2011-10-20 Thread Jeff Janes
On Tue, Oct 18, 2011 at 5:09 AM, kzsolt wrote: > Dear Anybody! > > I use pgr to store records. But the characterisitc of the record traffic are > special. For example 50 of them arrived in one sec contignously trough weeks > and aligned interally trough tables. What happens if the database has a

Re: [PERFORM] delete/recreate indexes

2011-10-20 Thread Bort, Paul
> An unrestricted update will end up rewriting the whole table. > It's advisable to run VACUUM afterward, so that the wasted > space can be reclaimed. What version are you on? Do you have > autovacuum enabled? > > Also, to take a step back, why do you try to keep the > timestamps changing like