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
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
:
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
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:
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
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
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
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,
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]
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
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.
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
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
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
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
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
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
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
= 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
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
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
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
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
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
/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
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
-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
. 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
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
,
Ivan Zolotukhin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
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
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
` 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
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
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
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
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
37 matches
Mail list logo