Yes, I was talking about 100 max connections...
I am doing some benchmarks tests with diferent configurations...
I'll try what you said Kevin.
Thank you All
2008/6/30 Kevin Neufeld <[EMAIL PROTECTED]>:
> I agree. I have a similar system that I use for development purposes and
> have the shared_
I agree. I have a similar system that I use for development purposes
and have the shared_buffers sitting comfortable around 1GB. On
production systems with 16GB of RAM, I've seen this as high as 12GB.
There is talk nowadays, however, that this setting could drop back down
to defaults on mode
Scott Marlowe escribió:
> On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
> > Rafael Domiciano escribió:
> >> The Postgres version is 8.3.3 and I am using Fedora Core 8.
> >> I have in the actual server around 70 connections the same time. I am
> >> assigning for this 1
On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Rafael Domiciano escribió:
>> The Postgres version is 8.3.3 and I am using Fedora Core 8.
>> I have in the actual server around 70 connections the same time. I am
>> assigning for this 100.
>
> 100 MB? That's not very muc
Rafael Domiciano escribió:
> The Postgres version is 8.3.3 and I am using Fedora Core 8.
> I have in the actual server around 70 connections the same time. I am
> assigning for this 100.
100 MB? That's not very much either. You can probably get a hefty
performance boost by upping it a lot more (
Updates = delete / insert
inserts only create dead tuples if they fail.
So, assuming no failed inserts, you're creating 55k dead tuples a day.
You can run vacuum verbose to get a report on how many dead tuples
your tables / database has to get an idea if you're vacuuming often
enough.
If vacuumi
No, but is more common Insert and Update than delete.
While I have around 50.000 Insert and Update, in delete is 5.000
2008/6/30 Alvaro Herrera <[EMAIL PROTECTED]>:
> Rafael Domiciano escribió:
> > I have schedelus to run vacuum at the night, it starts at 01:00 AM
>
> Do you execute lots of updat
Rafael Domiciano escribió:
> I have schedelus to run vacuum at the night, it starts at 01:00 AM
Do you execute lots of updates or deletes on some tables?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 su
I have schedelus to run vacuum at the night, it starts at 01:00 AM
2008/6/30 Alvaro Herrera <[EMAIL PROTECTED]>:
> Rafael Domiciano escribió:
> > No, i don't have autovacum.
> > We tried it sometime ago, and the applications began to take "time-out".
> > I think we don't need autovacum, along the
Rafael Domiciano escribió:
> No, i don't have autovacum.
> We tried it sometime ago, and the applications began to take "time-out".
> I think we don't need autovacum, along the day the application don't get
> slow, sometimes is faster (maybe the use of the applications is less).
> The actual machin
No, i don't have autovacum.
We tried it sometime ago, and the applications began to take "time-out".
I think we don't need autovacum, along the day the application don't get
slow, sometimes is faster (maybe the use of the applications is less).
The actual machine is Dual Core Xeon 1.5 and 2 Gb RAM.
Rafael Domiciano escribió:
> Yes, the server just does S, U, I and D.
> The queries is pretty simples, don't have huge joins across tables...
> In this server I have around 500 tables, the largest are:
> 9 millions tuples | 5 millions tuples
>
> This server is our "authenticator"; the response is
Yes, the server just does S, U, I and D.
The queries is pretty simples, don't have huge joins across tables...
In this server I have around 500 tables, the largest are:
9 millions tuples | 5 millions tuples
This server is our "authenticator"; the response is need to be "imediatly".
Today, the moni
On Mon, Jun 30, 2008 at 04:01:14PM -0300, Rafael Domiciano wrote:
> The Postgres version is 8.3.3 and I am using Fedora Core 8.
> I have in the actual server around 70 connections the same time. I am
> assigning for this 100.
And what does the server do? Mainly SELECT / UPDATE / INSERT / DELETE,
h
The Postgres version is 8.3.3 and I am using Fedora Core 8.
I have in the actual server around 70 connections the same time. I am
assigning for this 100.
2008/6/30 Tino Schwarze <[EMAIL PROTECTED]>:
> On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:
>
> > Folks, I am configuring
On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:
> Folks, I am configuring a new Postgres Server, that's gonna substitute the
> critical server of the enterprise.
> I have a good machine:
> Quad-Core 2.5 Ghz
> 4 Gb RAM
> 1 Dedicated HD 300 Gb Sata for the PostgreSQL Directory
If
16 matches
Mail list logo
