[GENERAL] managing kernel

My sysadmin has changed the values for shmall to 256MB (268435456) and shmmax to 1GB (1073741824) and I wonder if these values seem ok to you. We are working on a linux system (2.4 kernel) and have 2 GB RAM at our disposal. I have this large database running (15 million records). Are there any

Re: [GENERAL] managing kernel

OK, I have RTFM:-) SHMALL Total amount of shared memory available (bytes or pages) if bytes, same as SHMMAX; if pages, ceil(SHMMAX/PAGE_SIZE) These values should be the same. I've changed that now. Still my second question is valid though. Are there any other values I should consider

[GENERAL] Help! Access is Denied Installation on WinXP rolled back

Hi All! I googled for a solution to my problem and then searched the PostgreSQL site for solutions and since neither produced an answer I thought I'd see if anyone else out there knows how to resolve my dilemna... Any assistance is appreciated! Essentially what happens is that I just

Re: [GENERAL] SQL Question

Julian Scarfe wrote: From: Alex [EMAIL PROTECTED] - How can i select only the newest record for each ProdId ? 100| 2005-04-01 200| 2005-04-01 DISTINCT ON was made for this and on the similar tables I have performs rather more efficiently than using a subquery. select distinct on (ProdId)

Re: [GENERAL] Help! Access is Denied Installation on WinXP rolled

log file it tells me to check before it deletes it in the rollback it says repeatedly something about access is denied. Below is the actual install log (or a small portion of it, near the end where the error occurs). Any ideas? Regards, Abe p.s. this is a repost from my initial post on the

Re: [GENERAL] managing kernel

You'll probably want to take a look at this performance tuning reference: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html and this annotated configuration file: http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html -tfo -- Thomas F. O'Connell Co-Founder,

[GENERAL] Could not read block during vacuum

My company's product is developing a product using postgres 7.4.6 on a Linux 2.6.10 or 11 kernel, (don't have the exact version handy). We do vacuum verbose analyze daily. Two days after the database was created and loaded with a small amount of data (megabytes), the postgres logs had this line:

Re: [GENERAL] Could not read block during vacuum

[EMAIL PROTECTED] writes: 2005-04-16 00:00:53 ERROR: could not read block 52 of relation idx_ef_hash: Input/output error Googling didn't turn up useful information on this problem. Can anyone tell me whether this error indicates a disk problem, OS problem, known postgres bug, or

[GENERAL] Exception handling: Oracle's SQLERRM keyword option?

Hi, I have installed PostgreSQL 8.0.1 on Solaris 9. I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language. In Oracle we can get errormessagefrom SQLERRM keyword and insert messages into log table. How can I get errormessage/error codein PostgreSQL

Re: [GENERAL] [PATCHES] Exception handling: Oracle's SQLERRM keyword option?

Dinesh Pandey [EMAIL PROTECTED] writes: Pls help me or send me some example. Please do not post requests for help on pgsql-patches ... there is no Postgres list on which they are further off-topic. regards, tom lane ---(end of