[GENERAL] First inserts are faster than second ones

2010-07-28 Thread AlannY
Hi there. I have a strange behaviour about INSERT execution. I have very dummy PL/pgSQL function, which SELECT data from table; if data exists - skip, if not - add one. It's about 3'000'000 execution per program life. Everything works. But there are one weird thing. After DROP TABLE and then CREA

[GENERAL] What to do if space for database decrease and no additional hard drive is possible?

2010-07-26 Thread AlannY
Hi there. I have a huge database with several tables. Some tables have statistics information. And it's very huge. I don't want to loose any of this data. But hard drives on my single server are not eternal. Very soon, there will be no left space. And the most awful this, that it's a 1U server, an

Re: [GENERAL] Add pg server to cluster

2009-12-07 Thread AlannY
On Mon, Dec 07, 2009 at 01:12:03PM -0500, Scott Mead wrote: > On Mon, Dec 7, 2009 at 10:35 AM, AlannY wrote: > > You have a couple of options: > > NFS > > Works well, just make sure you're running with 'sync' enabled, or > you could lose

[GENERAL] Add pg server to cluster

2009-12-07 Thread AlannY
Hi there. I'm using PostgreSQL as my main database engine. Everything works. I have one server for PostgreSQL, and space on it are lowing down. I want to buy a new server and somehow connect it with first one, that PostgreSQL will use this new server's HDD. I don't want to buy new HDD for the fi

[GENERAL] invalid byte sequence for encoding "UNICODE"

2008-07-24 Thread AlannY
Hi there. Many times, I'm confronting with that strange problem: invalid byte sequence for encoding "UNICODE". So, I guess, Postgresql can't allow me to use some symbols which is not a part of UNICODE. But what is that symbals? I'm attaching a screenshot with THAT dead-symbol. As you can see

[GENERAL] Get index information from information_schema?

2008-03-17 Thread AlannY
Hello, there. I need a method of extracting information about indexes of any table from information_schema. Have you any suggestions? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

[GENERAL] Get info about indexes

2008-03-17 Thread AlannY
Hello, there. I need a method of extracting information about indexes of any table from information_schema. Have you any suggestions? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq