Up...
2012/5/18 Igor
> Good day.
>
> Continuing the subject about DB cluster based on plproxy - a question for
> developers:
>
> Is it possible to manage schema visibility from one database for different
> databases, at least in the read-only mode ? For example as schema
to compile hv.cc via g++.
I'm aware of c++ name [de]mangling, just looking if there's a standard way of
using C++ when it comes to pgxs.
--
Best Regards,
Igor Shevchenko
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
1. Is this possible in future releases ?
2. How I can organize interconnect between two clients connected to
different DB ? I need call NOTIFY from pgsql function in one database to
another LISTEN client in another database.
--
Regards
> Its real situation. We use sharded cluster based on plproxy. The calling
>> function for DB queries is equal in all databases (see plproxy
>> documentation). Now we need to release some internal logic between clients
>> based on certain events which occurred in this functions. The LISTEN/NOTIFY
>
Good day.
Continuing the subject about DB cluster based on plproxy - a question for
developers:
Is it possible to manage schema visibility from one database for different
databases, at least in the read-only mode ? For example as schema
pg_catalog.
Or is it possible to create FDW on the "shared m
probably a problem
w/ my hdd/memory, but still it'd be interesting to know which options do I have
in such situation.
--
Best Regards,
Igor Shevchenko
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Thank u for hint it really helped me - I made initdb with new lc-ctype
and lc-collate
settings : ru_RU:UTF8.
But im still having one question - some functions - lower() and upper()
doesnt work properly . what im doing wrong?
Tom Lane wrote:
igor <[EMAIL PROTECTED]> writes:
why &qu
Greatings!
Help me please to resolve my problem.
As appeared, postgesql server doesn't rollback transaction,
when I use
C++ Builder environment. May be sombody have
an idea, how to make it work?
The test source in the bottom of the letter.
I will be very greatefull for any help.
Greatings!
Help me please to resolve my problem.
As appeared, postgesql server doesn't rollback transaction
in C++ Builder environment. May be sombody have
an idea, how to make it work?
The test source in the bottom of the letter.
I will be very greatefull for any help.
This is the test message only
Hi,
I'm having a problem while dump database (I'm trying
to upgrade from 6.5 to 7.03) . The error message is:
dumpSequence(val_tmp_uid_seq): 0 (!=1) tuples returned by SELECT
Tell me please, what wrong in my database?
Thanks!
Igor.
s die...
May be there is anoter way for insertion ?
Thanks for any suggestion!
Igor
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
Help me please to resolve my problem. It is during vacuuming
database .I resolved it last time in such a way: pg_dump and
psql -e dbhttp://www.postgresql.org/search.mpl
Sorry, I clean forgot to tell
I'm running PG v7.02.
>> Help me please to resolve my problem.
TL> Postgres version?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
Tell me please, how to alter tables with arrays
(in other words - to change the dimension of array )
I'm running PG 7.1.2
Thanks for any suggestions .
Igor
---(end of broadcast)---
TIP 2: you can get off all lists at once wit
Hello,
Thank you for replay , but i still having problems with aray..
Well, i have a field OSTV which has dimention [1:9][1:6]
(i can see it in "SELECT array_dims(ostv) FROM mytable")
when i'm trying:
"update mytable set ostv [10][3]=333.00"
i got:
"Error while executing the query (non-fatal)
Hi,
Will calling ANALYZE table; twice in a row actually run the command twice ?
Or there is some sort of check that if the table is not changed since the
time of first call the second command will not actually be run?
Thanks,
Igor
above it will give
{ "Plan": { "Node Type": "Seq Scan", "Relation Name": "a", "Alias": "a",
"Startup Cost": 0.00, "Total Cost": 10372.75, "Plan Rows": 1230, "Plan
Width": 36, "Plans": [ { "Node Type": "Limit", "Parent Relationship":
"SubPlan", "Subplan Name": "SubPlan 1", "Startup Cost": 0.14, "Total Cost":
8.41, "Plan Rows": 1, "Plan Width": 4, "Plans": [ { "Node Type": "Index
Scan", "Parent Relationship": "Outer", "Scan Direction": "NoMovement",
"Index Name": "b_shape_idx", "Relation Name": "b", "Alias": "b", "Startup
Cost": 0.14, "Total Cost": 8.41, "Plan Rows": 1, "Plan Width": 4, "Index
Cond": "(shape && a.shape)", "Filter": "((kind <> 1) AND
_st_contains(shape, a.shape))" } ] } ] } }
Unfortunately I cannot provide data to reproduce the query plan results.
Thanks,
Igor
custom) lets you winnow a result
> set down to just one of the inputs.
>
> P.
>
>
> On Wed, Mar 4, 2015 at 6:36 AM, Igor Stassiy wrote:
> > Hello,
> >
> > I have a query plan optimization question. It is formatted nicely on
> >
> > http://stackoverflo
http://stackoverflow.com/questions/28856452/postgres-not-using-gist-index-in-lateral-join
On Thu, Mar 5, 2015 at 11:54 AM Alban Hertroys wrote:
>
> > On 04 Mar 2015, at 22:18, Igor Stassiy wrote:
> >
> > I would like to stop executing the query for a row of table "a"
Just create global temp tables once with “ON COMMIT PRESERVE ROWS“ option, and
when any session uses them their contents will be private to this session.
Regards,
Igor Neyman
From: inspector morse [mailto:inspectormors...@gmail.com]
Sent: Thursday, March 05, 2015 10:37 AM
To: Adrian Klaver
Cc: Merlin Moncure; Igor Neyman; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sharing data between stored functions?
I'm confused with what Igor said. He said to c
;
> Compatibility
>
> The CREATE TABLE command conforms to the SQL standard, with exceptions
> listed below.
>
> Temporary Tables
>
> >
> > Regards,
> > Igor Neyman
> >
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
m.b. I'm mis
HNAME'
can be used as
PG_CONFIG = pg_config
PGXS_PKGLIBDIR = $(shell $(PG_CONFIG) --pkglibdir)
PGXS_MODULESDIR = $(shell $(PG_CONFIG) --sharedir)/extension
in another Makefile?
Thanks,
Igor
Hello,
is there any difference between LWCOLLECTION and LWCOMPOUND? Has the
meaning changed since postgis 1.5 (when liblwgeom wasn't yet packaged) to
liblwgeom >= 2.0?
Also, what does LWCIRCSTRING stand for? Is it a closed line string?
Thanks a lot,
Igor
the memory context and
when a memory context is "closed" the entire memory allocated within would
be freed. But lwalloc by default is malloc, so does Postgres do something
extremely clever like overriding malloc with its palloc?
Thank you,
Igor
; Seq Scan on z0
(cost=0.00..1538.30 rows=42530 width=38) (actual time=0.010..82.125
rows=42530 loops=1)"
"Total runtime: 4414.655 ms"
--
Didn't see replies to this message, so...
Your query spends most of the time on sorting:
"Sort Method: external merge Disk: 21648kB"
and it doesn't fit in memory.
Try increasing work_mem somewhat to 50MB, you could do it for this particular
connection only, if you don't want to change it for the whole server.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, your RAM is 8GB. Your work_mem is too high. Actual memory used for
sorting, etc... could be multiples of work_mem setting.
That could be the reason for your memory problems. I'd suggest to set it to
16MB, and see if you can avoid "on disk" sorting. If not - gradually increase
work_mem.
Regards,
Igor Neyman
urrounding the function call with
PG_TRY/CATCH however these macros are not present in Postgis code.
Can you please suggest how to implement this functionality in my code?
Thanks,
Igor
B.col2
FROM table2 B
WHERE A.col3 = B.col4;
Regards,
Igor Neyman
200 GB ?
Thanks a lot,
cheers
Filip
---
PG 2.7 to 3.6???
Anyway, did you look at pg_upgrade?
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
database
using ODBC.
Thanks
Stuart Richler
Montreal
Sure.
What appears to be a problem?
Igor Neyman.
cords while really getting only 1.
Regards,
Igor Neyman
From: Sheena, Prabhjot [mailto:prabhjot.si...@classmates.com]
Sent: Friday, June 05, 2015 2:38 PM
To: Igor Neyman; pgsql-general@postgresql.org; pgsql-performa...@postgresql.org
Subject: RE: Query running slow for only one specific id. (Postgres 9.3) version
When I run vacuum analyze it fixes
t require much additional
resource, but will eliminate some network traffic that you have with the
current configuration.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
?
Please tell me what Im doing wrong?
And another question, if I want to specify remote postgres DB's in the .ini
file. How do I do that?
Thanks
Ali.
You should specify pgbouncer with “-d” option:
-bash-4.2$ psql -p 6432 –d pgbouncer
Regards,
Igor Neyman
g the other 2?
Thank you,
Igor
rsion from text
->internal is significantly slower than that of from internal -> text).
I will also try your suggestion with limiting the ids range.
On Tue, Jul 14, 2015 at 1:42 PM David Rowley
wrote:
> On 14 July 2015 at 21:12, Igor Stassiy wrote:
>
>> Hello,
>>
>
Julien, I have the following setting for WAL level: #wal_level = minimal
(which defaults to minimal anyway)
On Tue, Jul 14, 2015 at 6:19 PM Julien Rouhaud
wrote:
> On 14/07/2015 11:12, Igor Stassiy wrote:
> > Hello,
> >
> > I am benchmarking different ways of putting dat
I can't
take it down then change some parameters and start it up with again).
On Tue, Jul 14, 2015 at 6:37 PM Julien Rouhaud
wrote:
> On 14/07/2015 18:21, Igor Stassiy wrote:
> > Julien, I have the following setting for WAL level: #wal_level = minimal
> > (which defaul
write to wal if the wal_level is
minimal and hence cuts IO about in half.
On Tue, Jul 14, 2015 at 1:42 PM David Rowley
wrote:
> On 14 July 2015 at 21:12, Igor Stassiy wrote:
>
>> Hello,
>>
>> I am benchmarking different ways of putting data into table on table
>>
0) a limit
10;
and then check the size of the indexes:
for "select pg_relation_size('U1')" I get 2834432
while " select pg_relation_size('U2')" returns 2285568.
So, index based on randomly populated column is bigger than the one based on
sequentially pop
('12.32.42','.',-1) ,any help appreciated
__
There are lots of string functions and operators:
http://www.postgresql.org/docs/9.3/static/functions-string.html
There is definitely a replacement for Oracle’s instr(…).
Regards,
Igor Neyman
from information_schema.columns where
table_name = 'install_crash';
Regards,
Igor Neyman
healthcare domain (
irrespective of open-source or proprietary tool )
We need to showcase to our customer for building analytical database
Please do share, it will be really helpful
Thanks
Sridhar BN
Did you check this page:
http://www.postgresql.org/about/users/
Regards,
Igor Neyman
al PK (for db convenience) and unique NATURAL
key (for GUI representation).
Regards,
Igor Neyman
ust for the sake of completeness...
If the value (empname in the above example) can be NULL, the compare does not
work, because
SELECT NULL = NULL
returns NULL which is treated as FALSE.
But I am sure you know this :-)
HTH,
Ladislav Lenart
___
Right. And that
d but doesn't address
this use-case. It's unfortunate that we don't have a better answer at this
time.
Thanks!
Stephen
___
Could you please provide reference to pg_audit?
TIA,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
ent sequnce values, table data, views and functions.
As always, use with caution.
--
Melvin Davidson
I assume you are aware that this script does not produce complete copy of the
source schema.
Foregn Key constraints are not recreated along with the tables.
Regards,
Igor Neyman
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Wednesday, September 09, 2015 4:48 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] clone_schema function
Thanks Igor,
hmm, apparently the "INCLUDING CONSTRAINTS' option of "CREATE TABLE' ha
f schema “vector” is copied into some destination schema
using your script?
Melvin, you needn’t consider every critique of your script to be a personal
attack on you.
Regards,
Igor Neyman
ect column “field” from table “new”, which does not exists.
Not sure, what other example you need.
Regards,
Igor Neyman
in schema “new”.
The obvious problem is that there is no table “new” in schema “new”, the table
will still be called “old”.
Jim’s example is very similar to what I provided a few days ago.
Regards,
Igor Neyman
tml
Regards,
Igor Neyman
n
load_id else null end );
how can i convert case expressed to postgres..above it is oracle.
any help appreciated...
CREATE UNIQUE INDEX idx_load_pick ON pick (load_id) where picked='y';
Regards,
Igor Neyman
Hi All,
How to change sql format to look beautiful and understandable using
pgadmin3 or else ther tools for postgres.
any help appreciated..
Are you looking for SQL editor?
If that’s the case, take a look at contexteditor.org
Regards,
Igor Neyman
From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: Monday, September 28, 2015 3:14 PM
To: Igor Neyman
Cc: Ramesh T ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Format
On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman
mailto:iney...@perceptron.com>> wrote:
OM my_table
WHERE (x*10 + y) >= (1*10 + 3) AND (x*10 + y) <= (3*10 + 2)
ORDER BY x, y;
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
r: 212699113
Total runtime: 201995.044 ms
(7 rows)
What if you rewrite your second query like this:
SELECT ac.*
FROM balances ac JOIN customers o ON (o.id<http://o.id> = ac.customer_id AND
o.group_id = 45);
Regards,
Igor Neyman
From: Sean Rhea [mailto:sean.c.r...@gmail.com]
Sent: Friday, October 09, 2015 4:30 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Merge join vs merge semi join against primary key
It does the merge (not-semi) join:
production=> explain analyze SELECT ac.* F
it to work with records that comes from stdin (in
hex format for example).
How can this be done?
Thank you,
Igor
ld be greatly
appreciated.
Do you know what “process 41915” is? And what it was doing to cause
ExclusiveLock?
Regards,
Igor Neyman
What is the current plans for bigintarray?
Igor
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
reate new db).
Probably your unexpected table and sequence are coming from there.
Regards,
Igor Neyman
oon as your bulk load is finished.
Yours,
Laurenz Albe
--
Francesco,
Check CREATE UNLOGGED TABLE... in the docs.
Regards,
Igor
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
Igor Sfiligoi
# explain select id, b1_name from v;
QUERY PLAN
Nested Loop (cost=1.02..5.45 rows=1 width=6)
Join Filter: (c.b3_id = b3.id)
-> Nested Loop (cost=1.02..4
I was hoping this use case would fit in.
Any suggestions?
Igor
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Friday, July 01, 2016 12:42 PM
To: Sfiligoi, Igor
Cc: pgsql-general@postgresql.org
Subject: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless
n any of the useless
tables, and I am not returning any columns from those tables either.
Both is known at planning time.
Or is my logic still broken?
Thanks,
Igor
-Original Message-
From: Kevin Grittner [mailto:kgri...@gmail.com]
Sent: Friday, July 01, 2016 1:29 PM
To: Sfiligoi, Igo
..1.06 rows=6 width=4)
-> Seq Scan on a (cost=0.00..1.04 rows=4 width=4)
-> Seq Scan on b b3 (cost=0.00..1.06 rows=6 width=4)
(14 rows)
Igor
PS: Here are the updated table definitions:
create table a (id int not null primary key, name varchar(128));
create table b (id int not null pr
OK. Will change our query generation code to not use the view.
(I have tried the LEFT JOIN approach, but it just does not seem to perform.)
Thanks,
Igor
PS: Here are the numbers for the real production query (will not provide
details):
Original query: 300s
Query on a
The best that I can do right now is provide the explain of the three variants
(see below).
The use of a left join did indeed remove the useless joins, but the selected
plan is just terrible.
Thanks,
Igor
-Original Message-
From: Kevin Grittner [mailto:kgri...@gmail.com]
Sent
x27;{3}','{DELETE NOTIFY}');
Not tested and I've never used NOTIFY but the select makes it return rows.
I'm not positive how execution order plays out here, you may want to try
"VALUES()" instead of multiple columns.
David J.
Well,
“dblink_exec executes a command (that is, any SQL statement that doesn't return
rows) in a remote database.”
Regards,
Igor
can downgrade
to release 11.2.0.4."
So, you can downgrade only if you didn't "activate" newer feature (didn't
compatibility to higher version).
But then, what's the point in upgrading (I know, there are some like bug fixes,
etc...), if you aren't going to u
-Original Message-
From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
Sent: Thursday, July 28, 2016 11:26 AM
To: Igor Neyman ; Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 18:09, Igor Neyman wrote:
> -Origi
-Original Message-
From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
Sent: Thursday, July 28, 2016 11:26 AM
To: Igor Neyman ; Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 18:09, Igor Neyman wrote:
> -Origi
Regards,
Igor
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Tuesday, August 23, 2016 1:11 PM
To: pgsql-general
Subject: [GENERAL] Forward declaration of table
Good evening,
with PostgreSQL 9.5.3 I am using the
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Tuesday, August 23, 2016 3:33 PM
Cc: pgsql-general
Subject: Re: [GENERAL] Forward declaration of table
Hi Igor,
On Tue, Aug 23, 2016 at 8:15 PM, Igor Neyman
mailto:iney
on each of the
partition child tables. That would work, but it's a nuisance.
Thanks,
Craig
You can’t.
Only through triggers as you suggested.
Regards,
Igor
ustered index (with the heap row stored in the index leaf)
because of the way how MVCC implemented: multiple row versions are stored in
the table itself (e.g. Oracle for that purpose keeps table “clean” and stores
multiple row versions in UNDO tablespace/segment).
Regards,
Igor Neyman
a new row with a start ts
running on from that.
Of course, the adds are just inserting new rows.
cheers,
Chris
So, what is the value for "end ts", when the record is inserted (the range
ry'
else 'Owner_Inventory'
end) AS `Lot_Status`,
__
isnull(`s`.`Actual_Close_Date`) in MySQL is equivalent to:
s.actual_close_date IS NULL in Postgres.
What exactly didn't
, they are
not obligated to read your mind.
Regards,
Igor Neyman
er alternatives ? In Ingres for example
I can use dbevent and an esqlc app which listens
Thank you
Armand
__
Similar mechanism exists in Postgresql.
Read about LISTEN/NOTIFY in the docs.
be the possible ways, where i can look into.
Due to business impact auto vacuum is off.
Sent from Outlook<http://aka.ms/weboutlook>
You just stated the reason:
"auto vacuum is off"
Regards,
Igor Neyman
Hi, ALL,
This is my first post here.
I have actually 2 questions which are kind of related.
1. Is there an OSX version of the ODBC PostgreSQL driver?
1a. If there is none - is there an instructions on how to build and install it?
2. Is PostgreSQL ODBC driver works with iODBC?
Thank you.
--
Se
Adrian,
On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver
wrote:
> On 12/01/2016 08:01 AM, Igor Korot wrote:
>>
>> Hi, ALL,
>> This is my first post here.
>> I have actually 2 questions which are kind of related.
>>
>> 1. Is there an OSX version of the ODB
e]
Thank you.
On Thu, Dec 1, 2016 at 12:01 PM, Adrian Klaver
wrote:
> On 12/01/2016 08:41 AM, Igor Korot wrote:
>>
>> Adrian,
>>
>> On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver
>> wrote:
>>>
>>> On 12/01/2016 08:01 AM, Igor Korot wrote:
>&
Hi, Adrian,
On Thu, Dec 1, 2016 at 7:30 PM, Adrian Klaver wrote:
> On 12/01/2016 04:21 PM, Igor Korot wrote:
>>
>> Hi, guys,
>> I downloaded the latest sources, but the configure failed.
>> I have OSX 10.8 here.
>>
>> Which version of the driver is compa
Hi, ALL,
I have a text file which I got from exporting the SQLite database.
The file contains an SQL statement which will generate the database.
Excerpt from this file:
[code]
CREATE TABLE leagues( id INTEGER AUTOINCREMENT PRIMARY KEY, name
VARCHAR(100),balance DOUBLE(10,2));
CREATE TABLE player
Adrian,
On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver wrote:
> On 12/08/2016 04:54 AM, Igor Korot wrote:
>>
>> Hi, ALL,
>> I have a text file which I got from exporting the SQLite database.
>>
>> The file contains an SQL statement which will generate the
Adrian,
On Thu, Dec 8, 2016 at 9:54 AM, Igor Korot wrote:
> Adrian,
>
> On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver
> wrote:
>> On 12/08/2016 04:54 AM, Igor Korot wrote:
>>>
>>> Hi, ALL,
>>> I have a text file which I got from exporting the SQLi
Hi, guys,
On Thu, Dec 8, 2016 at 10:19 AM, Charles Clavadetscher
wrote:
> Hello
>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org
>> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
>> Sent: Donnerstag, 8. Dezembe
https://www.postgresql.org/docs/9.5/static/datatype-numeric.html,
I don't see a 'boolean' as supported data type.
Any idea what is the problem?
Thank you.
P.S.: Sorry for the top-post.
On Thu, Dec 8, 2016 at 10:14 PM, Tom Lane wrote:
> Adrian Klaver writes:
>>
Hi,
On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce wrote:
> On 12/10/2016 11:32 AM, Igor Korot wrote:
>>
>> Looking
>> athttps://www.postgresql.org/docs/9.5/static/datatype-numeric.html,
>> I don't see a 'boolean' as supported data type.
>
>
&g
Thank you Adrian.
That was it.
Now I can continue testing.
On Sat, Dec 10, 2016 at 11:26 PM, Adrian Klaver
wrote:
> On 12/10/2016 06:56 PM, Igor Korot wrote:
>>
>> Hi,
>>
>> On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce
>> wrote:
>>>
&g
Dear PSQL team.
I just found a weird problem.
When I pass a numeric type to a select for update statement, it locks loads of
rows, instead of a single one!
See explains below.
Is this a known bug (in 9.5)?
Any chance it was fixed in a more recent release?
Thanks,
Igor
Note: My table has
Uhm... maybe I misinterpreted the results.
Looking better, the root cause seems to be that the query planner is not using
the index, resorting to a seq scan instead.
OK... that makes more sense.
Sorry for the bogus email.
Igor
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general
ex on FK (col1, col2) are in the same order (and in the
beginning) of PK index.
So, no need for additional index (col1, col2).
Regards,
Igor Neyman
ightly worse
performance.
It seems like a huge improvement, given that your data fits BRIN's use case.
Felipe,
What kind of queries you used in your test?
Where they based on clustering columns?
Regards
Igor Neyman
1 - 100 of 505 matches
Mail list logo
