Re: [GENERAL] pg_start_backup() takes too long

2008-09-30 Thread Ivan Zolotukhin
On Mon, Sep 29, 2008 at 2:12 PM, Simon Riggs [EMAIL PROTECTED] wrote: On Mon, 2008-09-29 at 13:39 +0400, Ivan Zolotukhin wrote: This is all not about checkpoints. As I've mentioned in the first message, even right after manual run of CHECKPOINT command in psql pg_start_backup() takes same

Re: [GENERAL] pg_start_backup() takes too long

2008-09-29 Thread Ivan Zolotukhin
at 08:35 -0700, Joshua D. Drake wrote: Ivan Zolotukhin wrote: Hello, Nothing bad both in system and postgres logs :( No serious activity during backup. I've had to change statement_timeout for backup user to make it work. But I cannot reproduce this case unfortunately. This is actually

Re: [GENERAL] pg_start_backup() takes too long

2008-09-28 Thread Ivan Zolotukhin
: Ivan Zolotukhin wrote: Hello, What is the reason for select pg_start_backup('label'); taking 10 minutes on not so loaded system even right after manual checkpoint? No idea; something is seriously wrong if that is happening. Do the database server logs or kernel logs show anything

[GENERAL] pg_start_backup() takes too long

2008-09-10 Thread Ivan Zolotukhin
Hello, What is the reason for select pg_start_backup('label'); taking 10 minutes on not so loaded system even right after manual checkpoint? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] 8.3 on FreeBSD 6.3, sudden performance degradations

2008-09-08 Thread Ivan Zolotukhin
Hello, We experience sudden performance degradations on a PostgreSQL server used as a backend for pretty big web application. It's 16 GB RAM dedicated PostgreSQL 8.3.3 server with 2 x Quad Core Xeon 2.33 GHz running 6.3-PRERELEASE FreeBSD. postgresql.conf tweaked to match current configuration

Re: [GENERAL] interesting trigger behaviour in 8.3

2008-07-31 Thread Ivan Zolotukhin
On Tue, Jul 29, 2008 at 7:52 PM, Tom Lane [EMAIL PROTECTED] wrote: Ivan Zolotukhin [EMAIL PROTECTED] writes: In pseudo code it looks like the following. There are 2 tables, empty abstract_table with 3 columns (id, col1, col2) and many tables (e.g. inherited_table1_with_data) that inherit

[GENERAL] interesting trigger behaviour in 8.3

2008-07-29 Thread Ivan Zolotukhin
Hello, We came accross interesting behaviour of the update statement inside an after insert or update trigger in PostgreSQL 8.3.1. Briefly, the update run within one line trigger function takes always 1.5 sec whereas exactly the same update hitting the same rows takes always 1ms if run from the

Re: [GENERAL] storing latitude and longitude

2008-07-11 Thread Ivan Zolotukhin
Hello, Probably the simplest way is to use built-in point type and GiST index over box(point, point). You will be able to make flat geometrical calculations (e.g. distance with - operator) and retrieve data in the box given with index support. Regards, Ivan On Thu, Jul 10, 2008 at 9:25 PM,

Re: [GENERAL] Cannot drop user (PostgreSQL 8.1.11)

2008-06-03 Thread Ivan Zolotukhin
I recall I came across similar issue on older (8.1 or 8.2) versions of PostgreSQL some time ago. DB was pretty small so I dump-restored it eventually, but it looks like a bug anyway. I cannot reproduce it at 8.3. -- Regards, Ivan On Mon, Jun 2, 2008 at 7:12 PM, Maxim Boguk [EMAIL PROTECTED]

Re: [GENERAL] PL/R download

2008-05-29 Thread Ivan Zolotukhin
Still does not work for me, HTTP timeout On Tue, May 27, 2008 at 7:35 PM, Joe Conway [EMAIL PROTECTED] wrote: Cindy Makarowsky wrote: Is the PL/R download still available? The link is dead from the Postgres site and also at www.joeconway.com http://www.joeconway.com. Is there another

Re: [GENERAL] tsearch2 on-demand dictionary loading using functions in tsearch2

2008-05-23 Thread Ivan Zolotukhin
Hello, We definitely came across this issue recently. When new postgres backend is started it uses ~3MB of the memory accordingly to pmap. When one runs within this backend several typical queries that our application generates its consumed memory increases to 5-8MB which is not critical for us.

Re: [GENERAL] Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3

2008-04-16 Thread Ivan Zolotukhin
Hello, You may want to have a look also at PgSphere (http://pgfoundry.org/projects/pgsphere) and Q3C (http://q3c.sf.net) which is actually a spherical indexing solution built specially for PostgreSQL with the best performance among all other methods (even within other databases). Regards, Ivan

Re: [GENERAL] debug nonstandard use of \\ in a string literal

2008-03-04 Thread Ivan Zolotukhin
Thanks guys, this simple solution worked. Why didn't I guess before?.. On Thu, Feb 28, 2008 at 2:28 PM, Albe Laurenz [EMAIL PROTECTED] wrote: Ivan Zolotukhin wrote: From time to time I face with these well-known warnings in the PostgreSQL log, i.e. Feb 28 04:21:10 db7 postgres[31142

[GENERAL] debug nonstandard use of \\ in a string literal

2008-02-28 Thread Ivan Zolotukhin
Hello, From time to time I face with these well-known warnings in the PostgreSQL log, i.e. Feb 28 04:21:10 db7 postgres[31142]: [2-1] WARNING: nonstandard use of escape in a string literal at character 62 Feb 28 04:21:10 db7 postgres[31142]: [2-2] HINT: Use the escape string syntax for

Re: [GENERAL] Sthange things happen: SkyTools pgbouncer is NOT a balancer

2007-09-11 Thread Ivan Zolotukhin
AFAIK PgBouncer is not a balancer but a connection pooler. Skype said nothing about load balancing in its docs, so they are fair in this sense. Why did you decide it should balance the load? Regards, Ivan On 9/11/07, Dmitry Koterov [EMAIL PROTECTED] wrote: Hello. We discovered some time ago

Re: [GENERAL] How to switch off Snowball stemmer for tsearch2?

2007-08-22 Thread Ivan Zolotukhin
10 days is not suspicious at all if you need to pull out text for indexing using complex logic and/or schema (i.e. most of the time you retrieve text, not index it). Example: you index some tree leaves (i.e. table with 3 columns: id, parent_id and name) and want to have redundant text index. You

[GENERAL] Best practice for: ERROR: invalid byte sequence for encoding UTF8

2007-08-15 Thread Ivan Zolotukhin
Hello, Imagine a web application that process text search queries from clients. If one types a text search query in a browser it then sends proper UTF-8 characters and application after all needed processing (escaping, checks, etc) passes it to database. But if one modifies URL of the query

Re: [GENERAL] Best practice for: ERROR: invalid byte sequence for encoding UTF8

2007-08-15 Thread Ivan Zolotukhin
web site user can see some bad error (even if application caught this SQL exception for instance) otherwise. -- Regards, Ivan On 8/15/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote: On Wed, Aug 15, 2007 at 03:41:30PM +0400, Ivan Zolotukhin wrote: Hello, Imagine a web application

Re: [GENERAL] Best practice for: ERROR: invalid byte sequence for encoding UTF8

2007-08-15 Thread Ivan Zolotukhin
= On mbstring.substitute_character = none and broken symbols will be automatically stripped off from the input and output. But I am interested in general solution and better practices anyway... -- Regards, Ivan On 8/15/07, Phoenix Kiula [EMAIL PROTECTED] wrote: On 15/08/07, Ivan Zolotukhin [EMAIL PROTECTED] wrote

Re: [GENERAL] import content of XLS file into PostgreSQL

2007-08-08 Thread Ivan Zolotukhin
Hello, One more way to do it with mouse clicking only is OpenOffice. Get OO and install PostgreSQL driver into OpenOffice Database application, then you'll be able to import/export spreadsheets to and from database tables and work with DB tables just like they are spreadsheets. Regards, Ivan

Re: [GENERAL] import content of XLS file into PostgreSQL

2007-08-08 Thread Ivan Zolotukhin
Hello, On 8/8/07, Roberto Mello [EMAIL PROTECTED] wrote: On 8/8/07, Ivan Zolotukhin [EMAIL PROTECTED] wrote: Hello, One more way to do it with mouse clicking only is OpenOffice. Get OO and install PostgreSQL driver into OpenOffice Database application, then you'll be able to import

Re: [GENERAL] Modelling tags

2007-08-06 Thread Ivan Zolotukhin
Hello, I am thinking about how to model tags for a web site in the database. Is tsearch2 the way to do it? Yes, tsearch2 is the ultimate thing for all your text work in the PostgreSQL. Each site entry could then store its tags in a tsvector. That would make me able to perform partial

Re: [GENERAL] tsearch2 keep throw-away characters

2007-05-19 Thread Ivan Zolotukhin
Hello, Your problem is not about stop words, it's about the fact that tsearch parser treats '+' and '#' symbols as a lexemes of a blank type (use ts_debug() function to figure it out) and drops it without any further processing. AFAIK, typical solution for this is to rewrite your text and then

Re: [GENERAL] What about SkyTools?

2007-04-12 Thread Ivan Zolotukhin
I will test them intensively in coming weeks and report the results. I wrote an overview of the Skype PostgreSQL projects in Russian (will be published this week), so there will be more details available soon. In my opinion, SkyTools are worth testing, they look more interesting than Slony in

Re: [GENERAL] High-Availability Question

2006-07-04 Thread Ivan Zolotukhin
/project/slony1/genpage.php?howto_overview So you will need pgpool layer (or some other connection manager + network monitoring software) to detect failures anyway. Regards, Ivan Zolotukhin ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL and OpenVZ

2006-07-03 Thread Ivan Zolotukhin
server, it uses the copied stuff while starting up. Because the OpenVZ server starts with the same IP like the main database server, there is no need to change anything else while switching from main server to backup server. Regards, Frank. On Fri, 30 Jun 2006 18:37:27 +0400 Ivan Zolotukhin

[GENERAL] PostgreSQL and OpenVZ

2006-06-30 Thread Ivan Zolotukhin
-limited) load. Any caveats or limitations of this approach? Any known penalties or problems with this tandem? Best regards, Ivan Zolotukhin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Clearing out old idle connections

2006-05-24 Thread Ivan Zolotukhin
. But I'd prefer not to kill -QUIT these connections if there's something special for this situation built in PostgreSQL. Regards, Ivan Zolotukhin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [GENERAL] VACUUM FULL hangs on ordinary table

2006-05-20 Thread Ivan Zolotukhin
On 5/19/06, Tom Lane [EMAIL PROTECTED] wrote: Ivan Zolotukhin [EMAIL PROTECTED] writes: quite ordinary I think. When it hangs I see in `ps auxww` process with VACUUM waiting in its status. It's definitely waiting for a lock then. Yep, I checked that it waits for acquiring

Re: [GENERAL] No stddev() for interval?

2006-05-20 Thread Ivan Zolotukhin
, Ivan Zolotukhin ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] No stddev() for interval?

2006-05-20 Thread Ivan Zolotukhin
day' / 2; to get above weird result of 15 days and 12 hours. Regards, Ivan Zolotukhin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] VACUUM FULL hangs on ordinary table

2006-05-19 Thread Ivan Zolotukhin
40653 live rows and dead rows; 3000 rows in sample, 40653 estimated total rows Hope that someone explains me how's that possible. Thanks, Ivan Zolotukhin ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] statement_timeout and pg_dump

2006-05-18 Thread Ivan Zolotukhin
` not to let it fail because of the above timeout. But it seems that it's not possible to do long running pg_dump in this situation because it obviously fails when reaches timeout time. So are there any ways to increase timeout time for the dump procedure? Thanks, Ivan Zolotukhin

Re: [GENERAL] best practice in upgrading db structure

2006-03-29 Thread Ivan Zolotukhin
in advance. It takes 2-3 minutes to complete everything, but I would like to avoid it... Sincerely, Ivan Zolotukhin ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

2006-03-29 Thread Ivan Zolotukhin
want to contribute to PostgreSQL in this field? Sincerely, Ivan Zolotukhin ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

2006-03-29 Thread Ivan Zolotukhin
On 3/29/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Ivan Zolotukhin wrote: BTW, are there any plans for its improvement? What are the first steps for the people who want to contribute to PostgreSQL in this field? The first step would be making a detailed analysis of what XML support

[GENERAL] PostgreSQL's XML support comparison against other RDBMSes

2006-03-27 Thread Ivan Zolotukhin
Hello, Does anybody know good comparison/review article of XML support in major RDMBSes? I know that PostgreSQL's XML capabilities are quite weak, but how far is it from other products? Sincerely, Ivan Zolotukhin ---(end of broadcast)--- TIP 6