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
OK. Thanks for the info.
On Jun 30, 2008, at 5:48 PM, Stephan Szabo wrote:
I've found that if I run this select (below) I get a table returned
named 'dma' een though I specified like 'dm_%' :
Underscore is a special character for like matching any single
character
so I don't think that'
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
> I've found that if I run this select (below) I get a table returned
> named 'dma' een though I specified like 'dm_%' :
Underscore is a special character for like matching any single character
so I don't think that's wrong.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To m
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
Hi List;
I've found that if I run this select (below) I get a table returned
named 'dma' een though I specified like 'dm_%' :
select tablename from pg_tables where tablename like 'dm_%';
tablename
--
dm_service_provider_dim
dma
Am I missing somethi
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
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I see you didn't get a response this request. I am thinking it would be
> better to implement some form of massive change ownership option that
> can be done to change ownership after the dump is restored.
We already have REASSIGN OWNED, though that doe
On Mon, Jun 30, 2008 at 1:50 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> I see you didn't get a response this request. I am thinking it would be
> better to implement some form of massive change ownership option that
> can be done to change ownership after the dump is restored.
Currently the
I see you didn't get a response this request. I am thinking it would be
better to implement some form of massive change ownership option that
can be done to change ownership after the dump is restored.
---
[EMAIL PROTECTED]
Ok !
I could revoke privileges to postgres.pg_catalog from public but now new
users can login but can't see anything, even when I grant access to then on
one view I've created on a new database.
Can someone give a detailed stepe by step on how to achieve this:
- Probably change postgres and tem
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
Hello there,
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
My question is:
How much I could assign for the "Shared Buffers" par
On Montag, 30. Juni 2008 Thomas Bräutigam wrote:
> Why avoid RAID5?
RAID5 has very poor WRITE performance compared to RAID10, while READ is
nearly the same speed.
If you do not have a "branded" server like HP or IBM, I can recommend
the Areca RAID controllers http://www.areca.com.tw/ their driv
"Jan-Peter Seifert" <[EMAIL PROTECTED]> writes:
> I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME
> Apparently the default should be 'postgres'. However, the value changes with
> the user that is logged in whenever I use 'initdb --show'. If I login as 'xy'
> the value is 'x
How can I change that ?
I mean make the catalog of tables, function and roles private and only
accessible to granted users ?
Someon mentioned once to make changes in template1, wich changes will be
nneded ? In case this is possible.
Thanks for any help/sugestion !
On Fri, Jun 27, 2008 at 5:12 PM
On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote:
> Why avoid RAID5? I though that would be good? Can you explain this?
RAID5 has a lot of disadvantages, especially in terms of performance.
.oO(There was a link posted recently...)
> Writing in the DB, I add about 5-10 GB of data
Look this isn't the point I know what can be done with pg_hba.conf
The main point is:
When I create a postgresql user and grant to it only access to part of a
database (let's say one view). I'm expecting that the server will honor it.
But right now postgresql server isn't.
This is the reason I'm
Hi Tino,
Why avoid RAID5? I though that would be good? Can you explain this?
Writing in the DB, I add about 5-10 GB of data a day. There is a lot of writing
activity going on in the database every day.
What do you recommend how often I should backup the complete database?
Cheers Thomas
-O
On Mon, Jun 30, 2008 at 02:30:23PM +0200, Thomas Bräutigam wrote:
> I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra.
Thats plenty of data.
> What do you guys recommend on RAID Levels for this Database. Which
> does Postgres recommend, and with which do Postgres run very good or
> in th
Hello all,
I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. What do you guys
recommend on RAID Levels for this Database. Which does Postgres recommend, and
with which do Postgres run very good or in the best way?
What Backup Strategy do you think would be the best. Dump the DB once a
Hi,
I run out of disk space on the box and had to delete some files and restart
postgres. Ever since I have been getting the above message. PS shows this
process:
9351 ?D 0:04 postgres: startup process
Running an strace on this process shows that it is trying to write 8K of zeros
Hello,
I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME
Apparently the default should be 'postgres'. However, the value changes with
the user that is logged in whenever I use 'initdb --show'. If I login as 'xy'
the value is 'xy'. Shouldn't this be a fixed value in the clust
33 matches
Mail list logo
