Re: [GENERAL] pg_resetxlog command not found

2013-03-16 Thread viney
Is so easy use pg_config command sudo apt-get install libpg-dev use use pg_config command viney@viney ~ $ pg_config BINDIR = /usr/lib/postgresql/9.1/bin DOCDIR = /usr/share/doc/postgresql HTMLDIR = /usr/share/doc/postgresql INCLUDEDIR = /usr/include/postgresql PKGINCLUDEDIR = /usr/include/postgr

[GENERAL] sqlj.install_jar stalls

2013-03-16 Thread vidya.sagar
Hi, I am stuck with this problem since morning... Kindly help Postgre stalls ones i run SELECT sqlj.install_jar('file:///full/path/to/mypackage.jar','MyPackage',true); My Environment is as below: Windows7 postgresql-8.4.12-1-windows jdk-1_5_0_06-windows-i586-p PS: SELECT getsysprop('user.home

[GENERAL] High RAM usage on postgres

2013-03-16 Thread prashantmalik
Hello, We are facing very HIGH memory utilization on postgreSQL server and need help. Total RAM : 32GB Total CPU : 16cores --- *Table Size:* SEL

[GENERAL] Tunning postgresql.conf

2013-03-16 Thread komunca
Hi all, I have a server with 4 x Intel(R) Xeon(R) CPU E5640 @ 2.67GHz and * 12 GB* of memory. * There will be hosted ~100 databases with lot of reads and some writing. My postgresql.conf is:* listen_addresses = '*' max_connections = 300 shared_bu

Re: [GENERAL] How to use daterange type?

2013-03-16 Thread Christophe Pettus
On Mar 16, 2013, at 2:05 PM, Csanyi Pal wrote: > So how can I use this table further eg. to get dates of the school days > but without Saturdays and Sundays? You can't do that directly (that kind of calendar operation is outside of the scope of a range type). You can, however, easily write sel

Re: [GENERAL] How to use daterange type?

2013-03-16 Thread Ian Lawrence Barwick
2013/3/17 Csanyi Pal : > Hi, > > I'm using postgresql 9.2. > > I'm trying to figure out how can I use daterange type in my database > that is supposed to be a school calendar. > > I did the followings at the postgresql command prompt: > > create database schoolcalendar; > create table semester_1 (

Re: [GENERAL] Addled index

2013-03-16 Thread Tom Lane
Oleg Alexeev writes: > * it is varchar columns, 256 and 32 symbols length > * encoding, collation and ctype: UTF8, en_US.utf8, en_US.utf8 > * autovacuum, fsync off, full_page_writes = on, wal_writer_delay = 500ms, > commit_delay = 100, commit_siblings = 10, checkpoint_timeout = 20min, > checkpoint

[GENERAL] How to use daterange type?

2013-03-16 Thread Csanyi Pal
Hi, I'm using postgresql 9.2. I'm trying to figure out how can I use daterange type in my database that is supposed to be a school calendar. I did the followings at the postgresql command prompt: create database schoolcalendar; create table semester_1 ( schooldays daterange ); insert into semes

Re: [GENERAL] Addled index

2013-03-16 Thread Oleg Alexeev
On 16 March 2013 19:10, Tom Lane wrote: > Alban Hertroys writes: > > If there's actually something wrong with the database; it looks a bit > like your tables and your indexes get out of sync somehow, which normally > wouldn't be possible. I'm mostly guessing, but perhaps one of the below has > s

Re: [GENERAL] Addled index

2013-03-16 Thread Oleg Alexeev
On 16 March 2013 14:32, Alban Hertroys wrote: > On Mar 16, 2013, at 9:33, Oleg Alexeev wrote: > > On 16 March 2013 01:21, Steve Crawford wrote: > >> On 03/15/2013 11:29 AM, Oleg Alexeev wrote: >> >>> We've faced with strange index problem. >>> >>> At some moment index became bad and queries does

Re: [GENERAL] Addled index

2013-03-16 Thread Tom Lane
Alban Hertroys writes: > If there's actually something wrong with the database; it looks a bit like > your tables and your indexes get out of sync somehow, which normally wouldn't > be possible. I'm mostly guessing, but perhaps one of the below has something > to do with it: > Maybe you turned

[GENERAL] Analyzing the types of prepared statements

2013-03-16 Thread Jason Dusek
Hello List, My colleagues and I have some interest in creating an automated PG->Haskell bridge, that will read the PG catalog for a particular namespace or namespaces and generate a Haskell module with functions of appropriate types, creating functions for each stored procedure and simple tuple ty

Re: [GENERAL] Addled index

2013-03-16 Thread Alban Hertroys
On Mar 16, 2013, at 9:33, Oleg Alexeev wrote: > On 16 March 2013 01:21, Steve Crawford wrote: > On 03/15/2013 11:29 AM, Oleg Alexeev wrote: > We've faced with strange index problem. > > At some moment index became bad and queries does not return any data. > > For example, there are two tables

Re: [GENERAL] Testing Technique when using a DB

2013-03-16 Thread Jasen Betts
On 2013-03-13, Joe Van Dyk wrote: > --047d7b6226a405604904d7d09001 > Content-Type: text/plain; charset=UTF-8 > > On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford < > scrawf...@pinpointresearch.com> wrote: > >> On 03/12/2013 09:05 PM, Perry Smith wrote: >> >>> To all who replied: >>> >>> Thank you.

Re: [GENERAL] Addled index

2013-03-16 Thread Oleg Alexeev
On 16 March 2013 01:21, Steve Crawford wrote: > On 03/15/2013 11:29 AM, Oleg Alexeev wrote: > >> We've faced with strange index problem. >> >> At some moment index became bad and queries does not return any data. >> >> For example, there are two tables - A (id, name) and B (id, name, a_id). >> B.a