Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Replication...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 34 of 48 Topic 4027 of 4361
Post > Topic >>

Re: Replication Syatem

by pavan.deolasee@[EMAIL PROTECTED] ("Pavan Deolasee") Apr 29, 2008 at 06:46 PM

On Tue, Apr 29, 2008 at 6:42 PM, Gauri Kanekar
<meetgaurikanekar@[EMAIL PROTECTED]
> wrote:
> Thats how our updates works.
> We usually tend to touch the same row many times a day.
>

Then start with a non-100 fillfactor. I would suggest something like
80 and then adjust based on the testing. Since you are anyways have a
update intensive setup, leaving free space in the heap won't harm you
much in the long term.

Thanks,
Pavan

-- 
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 48 Posts in Topic:
Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:08:56 
Re: Replication Syatem
peterachilds@[EMAIL PROTE  2008-04-28 14:58:14 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:35:37 
Re: Replication Syatem
salmanb@[EMAIL PROTECTED]  2008-04-28 10:16:44 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:22:43 
Re: Replication Syatem
bnichols@[EMAIL PROTECTED  2008-04-28 10:13:20 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:47:22 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:48:48 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:23:45 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-28 13:39:39 
Re: Replication Syatem
radhika.sambamurti@[EMAIL  2008-04-28 16:58:59 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-28 17:43:57 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:25:10 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 01:20:04 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-29 10:48:28 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:41:33 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 01:08:09 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 11:16:57 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-29 20:49:38 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:17:05 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:25:27 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 04:37:07 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 10:16:02 
Re: Replication Syatem
vivek@[EMAIL PROTECTED]   2008-04-29 11:00:57 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 11:02:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 16:35:40 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:02:04 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-30 02:18:10 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 16:55:38 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:29:43 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:03:14 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:39:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:42:40 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:46:00 
Re: Replication Syatem
stark@[EMAIL PROTECTED]   2008-04-29 09:48:31 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 10:59:53 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 11:26:18 
Re: Replication Syatem
craig@[EMAIL PROTECTED]   2008-04-30 20:16:21 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 14:35:29 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 11:07:35 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 11:09:56 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:13:11 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 12:19:04 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:55:30 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 10:46:28 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 19:06:12 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 21:45:05 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 22:17:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 20:44:19 CDT 2008.