The following bug has been logged on the website:
Bug reference: 8408
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Any
Description:
There are simple test case:
create table test_columns (id serial primary
The following bug has been logged on the website:
Bug reference: 8176
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Any
Description:
Hi,
It seems that documentation wrong or [ CASCADE | RESTRICT ] feature of
The following bug has been logged on the website:
Bug reference: 7920
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.3
Operating system: Linux
Description:
sequence_name left stale after sequence rename:
Test case shows same
--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/ http://www.postgresql-consulting.com/
Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
МойКруг: http://mboguk.moikrug.ru/
People problems are solved with people
.
regards, tom lane
Thank you very much.
PS: I know that the query sounds stupid, but most CMS/ORM
unfortunately could produce unlimited amount of strange/stupid
queries.
--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/
--
Sent via pgsql-bugs mailing list
The following bug has been logged on the website:
Bug reference: 7703
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.1
Operating system: Any
Description:
Simple test case:
test=# create table test (id serial);
NOTICE: CREATE
The following bug has been logged on the website:
Bug reference: 7612
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.1
Operating system: Linux
Description:
Join between two values() set could produce wrong results:
Test case
On 10/19/12, Vik Reykja vikrey...@gmail.com wrote:
On Thu, Oct 18, 2012 at 5:40 PM, maxim.bo...@gmail.com wrote:
The following bug has been logged on the website:
Bug reference: 7612
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.1
The following bug has been logged on the website:
Bug reference: 7580
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.1
Operating system: Linux
Description:
create table t1 as select id from generate_series(1,10) as g(id
cluster - these settings could be lost forever after delete_old_cluster.sh .
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Maxim Boguk
Senior Postgresql DBA
The following bug has been logged on the website:
Bug reference: 7573
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.2.0
Operating system: Linux
Description:
Hi,
today while performing migration of test database (with no critical
Does that mean that file was damaged during rsync?
Not necessarily. When did you initially set up that cluster? Normally the
file
should get zeroed out before its being used. If the cluster was copied
improperly (i.e. no pg_start/stop backup or such) it could easily happen.
But
I would
The following bug has been logged on the website:
Bug reference: 7500
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.8
Operating system: FreeBSD
Description:
Hi,
Reinitialization of the replica after failover is procedure
I have kept all that database files for the future investigation.
What I should look into first?
Could you reproduce the error with log_error_verbosity=verbose? Or even
better
provide a backtrace with gdb?
There log with log_error_verbosity=verbose:
2012-08-21 14:04:18.973 MSK
Hi Andres,
I have some problems with debug startup process with gdb...
I following next sequence of commands (and got no useful results):
Youre debugging the postmaster that way. The easiest way would be to just
attach to the startup process with gdb -p. Not sure if you can manage that
On Wed, Aug 22, 2012 at 6:08 AM, Andres Freund and...@2ndquadrant.comwrote:
On Tuesday, August 21, 2012 03:30:44 PM Maxim Boguk wrote:
Hi Andres,
I would add something akin to
elog(WARNING, pid of startup is: %d, sleeping for 10s, getpid());
sleep(10);
Hi Andres,
There is it:
gdb
On Wed, Aug 22, 2012 at 1:50 PM, Maxim Boguk maxim.bo...@gmail.com wrote:
On Wed, Aug 22, 2012 at 6:08 AM, Andres Freund and...@2ndquadrant.comwrote:
On Tuesday, August 21, 2012 03:30:44 PM Maxim Boguk wrote:
Hi Andres,
I would add something akin to
elog(WARNING, pid of startup is: %d
The following bug has been logged on the website:
Bug reference: 6736
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.4
Operating system: FreeBSD
Description:
Hi,
May be it was fixed in more recent releases, but I can not find
The following bug has been logged on the website:
Bug reference: 6725
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.7
Operating system: Debian Linux
Description:
Hi,
On one of my production databases hot-standby server start
2012-07-10 03:31:35 MSK 12202 @ from [vxid:1/0 txid:0] [] PANIC: GIN
metapage disappeared
This is fixed in current minor releases.
http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=268ca4f57ea2dc3bf0dfb0f5c17fbda269b5d462
regards, tom lane
The following bug has been logged on the website:
Bug reference: 6662
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.1.3
Operating system: Linux
Description:
I managed create simple self-contained test case for 6658.
create table
concat an integer
directly to a text string.
regards, tom lane
--
Maxim Boguk
Senior Postgresql DBA.
Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
МойКруг: http://mboguk.moikrug.ru/
People problems are solved
On Wed, May 23, 2012 at 12:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
if anytextcat() and textanycat() are marked volatile,
why the database allows create index on supposedly to be volatile
expression:
create index test_val_special on test((val
The following bug has been logged on the website:
Bug reference: 6658
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.1.3
Operating system: Linux
Description:
Hi,
I have 2 queries which have the same plan/same performance on 8.3
The following bug has been logged on the website:
Bug reference: 6513
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.7
Operating system: Linux
Description:
I got hit by that bug when explored reasons of one very slow production
The following bug has been logged on the website:
Bug reference: 6422
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.1.2
Operating system: Linux
Description:
Hi.
Unfortunately I was hit by that problem in the real project.
During
:
Bug reference: 6393
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.6
Operating system: Linux Ubuntu
Description:
I have heavy write-load table under PostgreSQL 9.0.6 and sometime (not
always but more then 50% chance) i'm
The following bug has been logged on the website:
Bug reference: 6393
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.6
Operating system: Linux Ubuntu
Description:
I have heavy write-load table under PostgreSQL 9.0.6 and sometime
The following bug has been logged on the website:
Bug reference: 6359
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.1.2
Operating system: Ubuntu linux
Description:
Sometime Postgres inline subrequest even if it produce slower plan
the trick and resolved performance issues.
Do you plan create generalized inner indexscan mechanics for 9.2 version?
--
Maxim Boguk
The following bug has been logged on the website:
Bug reference: 6335
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.4
Operating system: Linux Ubuntu
Description:
I was explored reasons of high DB load and I localized the next
get enthused enough to try to fix the problem?
--
Álvaro Herrera alvhe...@commandprompt.com
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Maxim Boguk
Senior Postgresql DBA.
Phone RU: +7 910 405 4718
Phone AU: +61 45 218
On Thu, Dec 15, 2011 at 12:00 PM, bricklen brick...@gmail.com wrote:
On Wed, Dec 14, 2011 at 4:53 PM, Maxim Boguk maxim.bo...@gmail.com
wrote:
Here goes self-contained test case.
I tested it on the 9.1.2, 9.1.1, 9.0.5, 9.0.4, 8.4.7
I just tested on 9.1.2 and see the same issue.
--bad
efficiency?
--
Maxim Boguk
Senior Postgresql DBA.
On Mon, Nov 28, 2011 at 6:02 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Fri, Nov 25, 2011 at 6:33 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I know GIST on intarray[] do not have that problem.
Very likely the problem is limited to intarray[] GIN
On Fri, Nov 25, 2011 at 11:17 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Thu, Nov 24, 2011 at 11:12 PM, Maksym Boguk maxim.bo...@gmail.com
wrote:
postgres=# SELECT * from test where sections '{2000}';
id | sections
+--
(0 rows)
Ooops.
Can you see if this is
in locating and
fixing problem.
--
Maxim Boguk
Senior Postgresql DBA.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
in 9.1?
No, but I think psql prefers to set its encoding according to its locale
enviroment these days.
regards, tom lane
--
Maxim Boguk
Senior Postgresql DBA.
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
for more then year.
Can the second (16384 - /db/base/main) link be safely deleted?
--
Maxim Boguk
Senior Postgresql DBA.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following bug has been logged online:
Bug reference: 6097
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0 9.1beta
Operating system: Linux/Freebsd
Description:Server crash when enabling custom_variable_classes
Details:
I found
Ringer
--
Maxim Boguk
Senior Postgresql DBA.
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
If they can send one man to the moon... why can't they send them all?
МойКруг: http://mboguk.moikrug.ru/
Сила солому ломит, но не все в нашей
, Maxim Boguk maxim.bo...@gmail.com wrote:
Hi and thanks for responding...
While i performing my tests I used pg_dump via local socket
(
pg_dump -F c -Z 0 -t changes -a db /dev/null
)
Now:
billing=# SELECT * from db_activity ;
age | datname | procpid | usename | waiting
The following bug has been logged online:
Bug reference: 6087
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0
Operating system: Linux
Description:Unnest with multidimensional arrays
Details:
I not sure is it actual bug
The following bug has been logged online:
Bug reference: 5946
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4
Operating system: Linux
Description:Long exclusive lock taken by vacuum (not full)
Details:
From documentation I know
On Sat, Mar 26, 2011 at 4:17 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
In my case vacuum tried to truncate last 10-15GB from 100Gb relation, and
each time (3) it was cost 10+ minutes of service downtime (because that
table was completely locked
postgresql code.
Any help from more skilled persons would be great.
On Mon, Feb 21, 2011 at 10:07 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I tracked virtual tuple from heaptuple.c::slot_getattr down to
execMain.c::ExecUpdate and I think somewhere in this way
--
Maxim Boguk
Senior Postgresql DBA.
time today.
On Sun, Feb 20, 2011 at 12:01 PM, Maxim Boguk maxim.bo...@gmail.com wrote:
On Sun, Feb 20, 2011 at 5:08 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I finally managed create working slave server with non-stripped
Postgresql
8.4.7 and working
=0x7fffeb88) at
postmaster.c:1040
#41 0x005c0b5a in main (argc=3, argv=0x7fffeb88) at main.c:188
On Wed, Jan 5, 2011 at 4:28 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Dec 22, 2010 at 4:53 PM, Maxim Boguk maxim.bo...@gmail.com
wrote:
About stack backtrace I not sure how to get
values list.
On Sun, Feb 20, 2011 at 1:13 AM, Maxim Boguk maxim.bo...@gmail.com wrote:
Hi all and Hi Robert
I finally managed create working slave server with non-stripped Postgresql
8.4.7 and working gdb.
(sorry for such long delay).
And i can reproduce situation quite easy now, so i
On Sun, Feb 20, 2011 at 5:08 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I finally managed create working slave server with non-stripped
Postgresql
8.4.7 and working gdb.
(sorry for such long delay).
And i can reproduce situation quite easy now, so i
On Wed, Feb 16, 2011 at 6:18 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
Test case look like:
create table references ( attr_id integer, reference integer,
object_id integer );
insert into references select *100**(random()),
*10**(random()^*10
on references vm
(cost=0.00..0.53 rows=8 width=12) (actual time=0.028..37.242
rows=11701 loops=10)
Index Cond: ((vm.reference = rs.reference) AND (vm.attr_id = 10))
On Tue, Feb 15, 2011 at 4:27 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I found
The following bug has been logged online:
Bug reference: 5885
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.4
Operating system: Linux
Description:Strange rows estimation for left join
Details:
I found that strange effect while
On Tue, Dec 21, 2010 at 7:48 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
Bad explain:
billing=# EXPLAIN SELECT * from domains where
name='name=somedomain'::text::hstore-'name';
QUERY PLAN
20, 2010 at 9:48 PM, Maxim Boguk maxim.bo...@gmail.com wrote:
Anyone can enlighten me what happens here?
That does look weird, but without a simple test case I think it's
going to be hard to investigate this. Installing Slony and your code
and building a 130GB is more effort than I'm willing
The following bug has been logged online:
Bug reference: 5797
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.4
Operating system: Freebsd
Description:Strange bug with hstore
Details:
One day ago I analyzed slow query for one
The following bug has been logged online:
Bug reference: 5798
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.4
Operating system: FreeBSD 7.2
Description:Some weird error with pl/pgsql procedure
Details:
While I testing my table
The following bug has been logged online:
Bug reference: 5649
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.4
Operating system: FreeBSD 7.2
Description:strange (probably bugged) explain analyze output
Details:
I not sure
dropped column.
If this behavior is not a bug, than documentation should be changed
(because or to build a complete new record/row to return will never
work if table contained dropped columns).
On Mon, Jun 14, 2010 at 11:20 AM, Maxim Boguk maxim.bo...@gmail.com wrote:
I see... but anyway
-hackers/2010-03/msg00444.php
http://archives.postgresql.org/message-id/6645.1267926...@sss.pgh.pa.us
regards, tom lane
--
Maxim Boguk
Senior Postgresql DBA.
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
МойКруг
The following bug has been logged online:
Bug reference: 5328
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.1
Operating system: linux kernel v 2.6.18
Description:GIN index with fastupdates=on provide wrong result on
bitmap scan
62 matches
Mail list logo