Re: [ADMIN] Fwd: large cache

2009-06-29 Thread Scott Marlowe
On Mon, Jun 29, 2009 at 11:19 PM, Brian Modra wrote: > Hi, > my database requires 1TB of disk space, but I want to avoid RAID (e.g. > 8x 300GB SAS drives in RAID 10), and use rather a 1TB SATA disk. > To avoid the "slowness" of SATA showing in queries, I want to cache > lots of the database, but I

[ADMIN] Fwd: large cache

2009-06-29 Thread Brian Modra
Hi, my database requires 1TB of disk space, but I want to avoid RAID (e.g. 8x 300GB SAS drives in RAID 10), and use rather a 1TB SATA disk. To avoid the "slowness" of SATA showing in queries, I want to cache lots of the database, but I don't want to buy more than 16GB RAM. (Budget limits). So I'm c

Re: [ADMIN] unable to create new table

2009-06-29 Thread Chandra Sekar R
Hi, Raghu, Thank you for your info. i will see logs and postgresql.conf file and send to all. thanks R.Chandrasekar Accountant India Development Center Mobile: 9344564849 E-mail: chandrase...@visiontss.com Web: http://www.visiontss.com --- Vision Tech Solutions Pvt. Ltd., DD12, 4th Cros

Re: [ADMIN] unable to create new table

2009-06-29 Thread raghu ram
Hi, we can find below are the location of logs and postgresql.conf file windows:- C:\Program Files\PostgreSQL\8.2\data\pg_log C:\Program Files\PostgreSQL\8.2\data\postgresql.conf Linux:- /usr/local/pgsql/data/pg_log /usr/local/pgsql/data/postgresql.conf Thanks & Regards, Raghu On Tue, Jun

Re: [ADMIN] unable to create new table

2009-06-29 Thread Chandra Sekar R
Hi, Kevin, Thank you for your inputs. Since I am very new to Postgresql, how i can see logs and postgresql.conf file ? thanks Chandrasekar R. -- On 6/29/09, Kevin Grittner wrote: > > Chandra Sekar R wrote: > > > I have created 4 tables using PgadminIII in postgres db and public > > s

Re: [ADMIN] unable to create new table

2009-06-29 Thread Scott Marlowe
On Mon, Jun 29, 2009 at 9:57 PM, Greg Stark wrote: > On Mon, Jun 29, 2009 at 4:56 PM, Scott Marlowe wrote: >>> ERROR: invalid page header in block 95 of relation "pg_attribute". >> >> Are you running aanti-virus software on this machine?  That's a common >> cause of these issus on windows. > > Is i

Re: [ADMIN] unable to create new table

2009-06-29 Thread Greg Stark
On Mon, Jun 29, 2009 at 4:56 PM, Scott Marlowe wrote: >> ERROR: invalid page header in block 95 of relation "pg_attribute". > > Are you running aanti-virus software on this machine?  That's a common > cause of these issus on windows. Is it? I thought it mainly caused random errors when connecting

[ADMIN] how much memory (work_mem) is a query using?

2009-06-29 Thread Kevin Kempter
Hi all; is it possible to see how much work_mem memory a particular session is using? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Partioning in postgres

2009-06-29 Thread Richard Broersma
On Mon, Jun 29, 2009 at 12:19 PM, Bhella Paramjeet-PFCW67 wrote: > I tested a scenario where in one terminal window > I insert rows in the eventlog table in the BEGIN END loop and do not > commit the transaction. In another terminal window I create a new > partition but when I create a rule for th

[ADMIN] Partioning in postgres

2009-06-29 Thread Bhella Paramjeet-PFCW67
Hi, We are planning on implementing partioning in our postgres production database.=20 In my test system I created a table called eventlog which has 7 partitions. I have created rules for data to be inserted in respective partitions. I tested a scenario where in one terminal window I insert rows i

Re: [ADMIN] unable to create new table

2009-06-29 Thread Scott Marlowe
On Mon, Jun 29, 2009 at 12:20 AM, Chandra Sekar R wrote: > June 30, 2009 > > Hi All, > > I recently installed PostgreSQL 8.3.7 into my windows xp m/c. > I have created 4 tables using PgadminIII in postgres db and public schema > with PK, UK, > constraints and after I shutdown the pc. > > next time

Re: [ADMIN] unable to create new table

2009-06-29 Thread Kevin Grittner
Chandra Sekar R wrote: > I have created 4 tables using PgadminIII in postgres db and public > schema with PK, UK, constraints and after I shutdown the pc. Was PostgreSQL gracefully shutdown? (The logs should tell you.) > next time when i start my pc and I *unable to create new table* the >

Re: [ADMIN] analyze anomalie

2009-06-29 Thread Uwe Bartels
Hi Tom, I was running the command as user postgres (default). The "vacuum anlyze" and the "analyze" I run as the same user. client_min_messages is still set to default in the server config. reagrds, Uwe 2009/6/29 Tom Lane > Uwe Bartels writes: > > today i found an anomalie running > > analyze

Re: [ADMIN] analyze anomalie

2009-06-29 Thread Tom Lane
Uwe Bartels writes: > today i found an anomalie running > analyze verbose > the output was simply "ANALYZE", which tells me that analyze was running > successfully. but there was no verbose output. and in the statistics table > was no updated last_analyze column. Perhaps you didn't have permiss

[ADMIN] analyze anomalie

2009-06-29 Thread Uwe Bartels
Hi, today i found an anomalie running analyze verbose the output was simply "ANALYZE", which tells me that analyze was running successfully. but there was no verbose output. and in the statistics table was no updated last_analyze column. I run that automaticly in the background or manually in a