Re: [GENERAL] Tuning for a tiny database

2011-06-23 Thread CSS
Steve Atkins wrote: > On Jun 20, 2011, at 10:49 PM, CSS wrote: > >> Hello, >> >> I couldn't find much information in the archives on this -- perhaps this >> is a bit of a specialized need, but I was hoping for some input from >> some experienced postgres admins. >> >> I'm moving some DNS servers f

Re: [GENERAL] Tuning for a tiny database

2011-06-23 Thread CSS
Greg Smith wrote: > On 06/21/2011 01:49 AM, CSS wrote: >> Some raw numbers: We're only looking at a total of about six tables in >> one db. In total there are going to be well under 10,000 records in ALL >> tables. That might increase to at most 100,000 in the next few years. >> Our raw DNS queri

Re: [GENERAL] Tuning for a tiny database

2011-06-22 Thread Steve Atkins
On Jun 20, 2011, at 10:49 PM, CSS wrote: > Hello, > > I couldn't find much information in the archives on this -- perhaps this > is a bit of a specialized need, but I was hoping for some input from > some experienced postgres admins. > > I'm moving some DNS servers from djbdns/tinydns to PowerD

Re: [GENERAL] Tuning for a tiny database

2011-06-21 Thread Greg Smith
On 06/21/2011 01:49 AM, CSS wrote: Some raw numbers: We're only looking at a total of about six tables in one db. In total there are going to be well under 10,000 records in ALL tables. That might increase to at most 100,000 in the next few years. Our raw DNS queries/second tops out around 50 q

Re: [GENERAL] Tuning for a tiny database

2011-06-21 Thread Vincent Veyron
Le mardi 21 juin 2011 à 01:49 -0400, CSS a écrit : > I couldn't find much information in the archives on this -- perhaps this > is a bit of a specialized need, but I was hoping for some input from > some experienced postgres admins. > Hi, I am not an experienced postgres admin, but I am an exper

[GENERAL] Tuning for a tiny database

2011-06-20 Thread CSS
Hello, I couldn't find much information in the archives on this -- perhaps this is a bit of a specialized need, but I was hoping for some input from some experienced postgres admins. I'm moving some DNS servers from djbdns/tinydns to PowerDNS. While it supports many backends, postgresql seems li

[GENERAL] Tuning for a tiny database

2011-06-04 Thread CSS
Hello, I couldn't find much information in the archives on this -- perhaps this is a bit of a specialized need, but I was hoping for some input from some experienced pgsql admins. I'm moving some DNS servers from djbdns/tinydns to PowerDNS. While it supports many backends, postgres seems like th