Re: [GENERAL] Logical decoding client has the power to crash the server

wal_lsn() - confirmed_flush_lsn) AS lsn_distance FROM pg_catalog.pg_replication_slots WHERE slot_name = ''; provides a measure in Logical Replication environment of how far did (or did not) Subscriber fell behind Publisher, and hence some kind of measure of how much "extra&qu

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

I wonder, does plpgsql compilation check for existence of the add_job_history function or is that a runtime check? At runtime. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Igor Neyman Sent: Friday, June 02, 2017 9:45 AM To: PAWAN SHARMA <er.pawanshr0...@gmail.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2P

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

date, LOCALTIMESTAMP, OLD.job_id, OLD.department_id); RETURN NEW; END $BODY$ LANGUAGE 'plpgsql'; Regards, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, May 25, 2017 3:13 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, May 24, 2017 7:06 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, May 24, 2017 10:00 AM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BET

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 7:42 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 5:48 PM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 08:15 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

+, Igor Neyman <iney...@perceptron.com> wrote: >Interestingly, when I add this line to pg_hba.conf: > >localall all md5 > >Postgres is not starting with the following error in the log file: > >2017-05-23 11:02:10.397 EDT [4796] LOG: local conn

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Tuesday, May 23, 2017 10:04 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:52 AM, Igor

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 10:31 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 07:05 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:45 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:33 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer Sent: Tuesday, May 23, 2017 9:46 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA Igor Neyman schrieb am

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:26 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:17 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, May 22, 2017 7:56 PM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/22/2017 12:33 PM, Igor Neyman wrote

[GENERAL] logical replication in PG10 BETA

Hi, Does built-in logical replication work on Windows in PG10 BETA release? I can't make it working so far. I created Publication on "source" PG server, but when I'm trying to CREATE SUBSCRIPTION... on "destination" server, I'm getting: "ERROR: could not connect to the publisher: could not send

Re: [GENERAL] Different query plan used for the same query depending on how parameters are passed

the behavior. Why does the query planner choose to ignore the index when the command is parameterised? It’s because when optimizer builds execution plan for parametrized queiry, it doesn’t know what values for t1 and t2 will be provided for WHERE clause. Regards, Igor Neyman

Re: [GENERAL] PostgreSQL Required Monitoring

ce with Oracle: Postgres does not allocate disk space for data files “in advance” (like Oracle does). Regards, Igor Neyman

Re: [GENERAL] PostgreSQL Required Monitoring

just “idle” connections (and their state change – how long they’ve been idle), especially considering that unlike Oracle Postgres doesn’t have (yet) built-in connection pooler, so there is risk to run out of connections. There are very good add-on poolers such as PgBouncer, PgPool. Regards, Igor Neyman

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:11 PM To: Igor Neyman <iney...@perceptron.com>; Melvin Davidson <melvin6...@gmail.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Service outage: each postgres process use the e

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:00 PM To: Igor Neyman <iney...@perceptron.com>; Melvin Davidson <melvin6...@gmail.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Service outage: each postgres process use the e

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

-weight and easy to configure. Regards, Igor Neyman

Re: [GENERAL] advice for efresh of materialized view

a ram, and the excution time dropped from 10 to 2 minutes. Since I did everything with one shot, I can't tell the weight of every single action. Regards IF You can always run EXPLAIN ANALYZE and see what's going on. Also, it could show possibilities for improvement.

Re: [GENERAL] advice for efresh of materialized view

d_view ) takes about 8 minutes ( it takes about 3 to create the MV ). I'd like to know if there is a way to speed up the refresh ( or the creation ) with some additional indexes, maybe ? Thanks in advance ____ Also, in regards to: Sort Method: external merge Disk: 287784kB I'd increase work_mem setting, to avoid on-disk sorting. Regards, Igor Neyman

Re: [GENERAL] advice for efresh of materialized view

d_view ) takes about 8 minutes ( it takes about 3 to create the MV ). I'd like to know if there is a way to speed up the refresh ( or the creation ) with some additional indexes, maybe ? Thanks in advance ____ I'd try the following index: (giomo:date, categoria, utenti, action) on categories_stat table and see if it improves performance. Regards, Igor Neyman

Re: [GENERAL] pg_class (system) table increasing size.

__ You just stated the reason: "auto vacuum is off" Regards, Igor Neyman

Re: [GENERAL] executing os commands from a function

? 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. Regards, Igor Neyman

Re: [GENERAL] Update two tables returning id from insert CTE Query

t” way, David suggested one. If you aren’t willing, people will stop responding to your request, they are not obligated to read your mind. Regards, Igor Neyman

Re: [GENERAL] isnull() function in pgAdmin3

Status`, __ isnull(`s`.`Actual_Close_Date`) in MySQL is equivalent to: s.actual_close_date IS NULL in Postgres. What exactly didn't work for you? Regards, Igor Neyman -- Sent via pgsql-general mailing list

Re: [GENERAL] performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

ts, and then inserting 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

Re: [GENERAL] Clustered index to preserve data locality in a multitenant application?

e “clean” and stores multiple row versions in UNDO tablespace/segment). Regards, Igor Neyman

Re: [GENERAL] Foreign key against a partitioned table

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig James Sent: Tuesday, August 23, 2016 4:00 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Foreign key against a partitioned table How do you create a foreign key that references a

Re: [GENERAL] Forward declaration of table

:15 PM, Igor Neyman <iney...@perceptron.com<mailto:iney...@perceptron.com>> wrote: mailto:pgsql-general-ow...@postgresql.org<mailto:pgsql-general-ow...@postgresql.org>] On Behalf Of Alexander Farber https://gist.github.com/afarber/c40b9fc5447335db7d24 Certain MOVE exists onl

Re: [GENERAL] Forward declaration of table

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

Re: [GENERAL] Uber migrated from Postgres to MySQL

-Original Message- From: Alex Ignatov [mailto:a.igna...@postgrespro.ru] Sent: Thursday, July 28, 2016 11:26 AM To: Igor Neyman <iney...@perceptron.com>; Rakesh Kumar <rakeshkumar46...@gmail.com> Cc: PostgreSQL General <pgsql-general@postgresql.org> Subject: Re: [GENE

Re: [GENERAL] Uber migrated from Postgres to MySQL

-Original Message- From: Alex Ignatov [mailto:a.igna...@postgrespro.ru] Sent: Thursday, July 28, 2016 11:26 AM To: Igor Neyman <iney...@perceptron.com>; Rakesh Kumar <rakeshkumar46...@gmail.com> Cc: PostgreSQL General <pgsql-general@postgresql.org> Subject: Re: [GENE

Re: [GENERAL] Uber migrated from Postgres to MySQL

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex Ignatov Sent: Thursday, July 28, 2016 10:59 AM To: Rakesh Kumar Cc: PostgreSQL General Subject: Re:

Re: [GENERAL] Multiple NOTIFY is ignored

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Thursday, July 28, 2016 11:05 AM To: Markus Kolb Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Multiple NOTIFY is ignored On

Re: [GENERAL] Hot disable WAL archiving

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Job Sent: Friday, June 17, 2016 9:01 AM To: Albe Laurenz ; pgsql-general@postgresql.org Subject: [GENERAL] R: Hot disable WAL archiving Hi Albe

Re: [GENERAL] Drop/Re-Creating database extremely slow + doesn't lose data

e new db). Probably your unexpected table and sequence are coming from there. Regards, Igor Neyman

[GENERAL] pglogical

.4 and 9.5) on various Linux platforms, and I'm stuck with Windows, hence the question. If it didn't make 9.6 core, is there plan to include it in 9.7, or may be pglogical becomes available on Windows? Regards, Igor Neyman

Re: [GENERAL] Release Notes Link is broken on the website

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Allan Kamau Sent: Thursday, May 12, 2016 9:59 AM To: Daniel Westermann Cc: Postgres General Postgres General Subject: Re:

Re: [GENERAL] Increased I/O / Writes

dering how can I find the queries that are causing that much IO? Please, if anyone can share anything.. Thanks a lot! Lucas So, what’s wrong with using pg_stat_statements? It has a set of columns pertaining to IO. Regards, Igor Neyman

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

-Original Message- From: James Robinson [mailto:jlrob...@socialserve.com] Sent: Friday, March 25, 2016 11:29 AM To: Igor Neyman <iney...@perceptron.com> Cc: Melvin Davidson <melvin6...@gmail.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Way to get at parsed t

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

)” – looks like it doesn’t work with pg_trigger, because as a second parameter (Var) it expects relation_oid, and relation could have multiple triggers, so pg_get_expr() wouldn’t know which trigger’s tgqual you want to decompile. Regards, Igor Neyman

Re: [GENERAL] Including SQL files

w.postgresql.org/docs/9.5/static/ecpg-preproc.html seems to be something different? Regards Alex Psql directive \i – is your friend. In your words.sql: \i words_hash \i words_join_new_game \i … Regards, Igor Neyman

Re: [GENERAL] multiple UNIQUE indices for FK

W dniu 28.02.2016 o 03:35, David G. Johnston pisze: > W dniu 23.02.2016 o 09:39, Rafal Pietrak pisze: > > Can anybody suggest any other way out of this mass? > > > ​The only thought that sticks while reading your prose is:​ > > ​message > message-person < person​ > > >

Re: [GENERAL] Windows performance

ervers - Actual query you are using Regards, Igor Neyman

Re: [GENERAL] BRIN indexes

ith BTREE = completion time 10s / index size 5.000,00 MB As you can see, BRIN can save 99% of disk space for just a slightly 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

Re: [GENERAL] Can PostgreSQL use multi-column index for FK constraint validation?

Dane Columns in proposed index 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

Re: [GENERAL] Waiting on ExclusiveLock on extension 9.3, 9.4 and 9.5

be greatly appreciated. Do you know what “process 41915” is? And what it was doing to cause ExclusiveLock? Regards, Igor Neyman

Re: [GENERAL] Merge join vs merge semi join against primary key

1995.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

Re: [GENERAL] Merge join vs merge semi join against primary key

From: Sean Rhea [mailto:sean.c.r...@gmail.com] Sent: Friday, October 09, 2015 4:30 PM To: Igor Neyman <iney...@perceptron.com> 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=>

Re: [GENERAL] Selecting pairs of numbers

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

Re: [GENERAL] Format

From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Monday, September 28, 2015 3:14 PM To: Igor Neyman <iney...@perceptron.com> Cc: Ramesh T <rameshparnandit...@gmail.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Format On Mon, Sep 28, 2015 at 1:59 PM,

Re: [GENERAL] Format

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

Re: [GENERAL] to pg

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

Re: [GENERAL] @ operator

/docs/9.4/static/typeconv-oper.html Regards, Igor Neyman

Re: [GENERAL] clone_schema function

ect column “field” from table “new”, which does not exists. Not sure, what other example you need. Regards, Igor Neyman

Re: [GENERAL] clone_schema function

chema “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

Re: [GENERAL] clone_schema function

fig” referenced in some function. Now, what happens if 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

Re: [GENERAL] clone_schema function

From: Melvin Davidson [mailto:melvin6...@gmail.com] Sent: Wednesday, September 09, 2015 4:48 PM To: Igor Neyman <iney...@perceptron.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] clone_schema function Thanks Igor, hmm, apparently the "INCLUDING CONSTRAINTS' option of &q

Re: [GENERAL] log_statement = 'mod' does not log all data modifying statements

n for the back-branches is good 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@p

Re: [GENERAL] clone_schema function

ues, 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

Re: [GENERAL] UPDATE an updatable view

, Ladislav Lenart ___ Right. And that's why you use very nice option provided by PG: IF NEW.empname IS DISTINCT FROM OLD.empname THEN which again you probably know :) Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] PostgreSQL Developer Best Practices

to be changed eventually. So, my conclusion: use artificial PK (for db convenience) and unique NATURAL key (for GUI representation). Regards, Igor Neyman

Re: [GENERAL] PostgreSQL customer list

/ Regards, Igor Neyman

Re: [GENERAL] Get additional constraint information

from information_schema.columns where table_name = 'install_crash'; Regards, Igor Neyman

Re: [GENERAL] instr detail

('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

Re: [GENERAL] INSERT ... ON CONFLICT DO UPDATE

while select pg_relation_size('U2') returns 2285568. So, index based on randomly populated column is bigger than the one based on sequentially populated. But, on the other hand, after: reindex table test_index_size; both indexes are of the same size: 2260992. Regards, Igor Neyman

Re: [GENERAL] PgBouncer error - psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /var/run/postgresql/.s.PGSQL

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

Re: [GENERAL] [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

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

[GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version

. Regards, Igor Neyman

[GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version

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

Re: [GENERAL] Connection question

database using ODBC. Thanks Stuart Richler Montreal Sure. What appears to be a problem? Igor Neyman.

Re: [GENERAL] Help with slow table update

WHERE A.col3 = B.col4; Regards, Igor Neyman

Re: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6

with 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

Re: [GENERAL] how would you speed up this long query?

: 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

Re: [GENERAL] Would like to know how analyze works technically

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

Re: [GENERAL] Sharing data between stored functions?

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 create

Re: [GENERAL] Sharing data between stored functions?

conforms to the SQL standard, with exceptions listed below. Temporary Tables Regards, Igor Neyman -- Adrian Klaver adrian.kla...@aklaver.com m.b. I'm missing something, but this quote from docs doesn't explain why, it just states that feature is not implemented. Regards, Igor

Re: [GENERAL] Sharing data between stored functions?

PRESERVE ROWS“ option, and when any session uses them their contents will be private to this session. Regards, Igor Neyman

Re: [GENERAL] stored procedure variable names

using dynamic SQL variables inside EXECUTE ‘…’ are “positional” prefixed with ‘$’, eg.: $1, $2,… Regards, Igor Neyman

Re: [GENERAL] Issue dumping schema using readonly user

what's provided by Oracles DBMS_METADATA package. I'm not familiar with EnterprizeDB (Oracle-related) extensions of Postgresql, but they may have it implemented, check their docs. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Determine all listeners subscribed to notifcations and what channels

). Is there a way to find out which channels have listeners? thanks --Cory Take a look at pg_listening_channels() in PG docs. Regards, Igor Neyman

Re: [GENERAL] SELECT, GROUP BY, and aggregates

This works just fine. It's not in the spec, but postgres supports it. I'll leave it to others to argue about it being a best practice or not. --- I use this feature a lot. Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Error: could not read symbolic link pg_tblspc/940585. No such file or directory

. Regards, Igor Neyman

Re: [GENERAL] Avoiding deadlocks when performing bulk update and delete operations

do: DELETE FROM table_name WHERE id_A = ANY(array_of_id_A) AND id_B = ANY(array_of_id_B); ? Regards, Igor Neyman

Re: [SPAM] - [GENERAL] Performance of UPDATE SET = FROM vs UPDATE SET = (SELECT ...)

. 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

Re: [GENERAL] To increase RAM or not

/#comment-945 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

Re: [GENERAL] Misunderstanding deadlocks

resource that this query is looking for was not released by some other connection (user locked some object and went for a coffee break ☺ Regards, Igor Neyman

Re: [GENERAL] How to get good performance for very large lists/sets?

plans, and what don't you like about them? 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

Re: [GENERAL] How to get good performance for very large lists/sets?

-Original Message- From: Richard Frith-Macdonald [mailto:richard.frith-macdon...@brainstorm.co.uk] Sent: Monday, October 06, 2014 1:53 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to get good performance for very large lists/sets? On 6 Oct 2014, at 17

Re: [GENERAL] how to pass tablename to a function

where id between startid and stopid ) a where (up).userid is not NULL ) I want to pass the _tbl to the select query integrated in the unpacking(), how can I make it? thanks Alec You can't. You have to use dynamic sql (EXECUTE). Regards, Igor Neyman

Re: [GENERAL] postgresql_fdw issues with triggers on the foreign tables

NEW.id value nextval('...'::regclass) right then and there explicitly in such cases. Regards, Igor Neyman

Re: [GENERAL] Why is unique constraint needed for upsert?

care about such small things as ACID. 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

Re: [GENERAL] PG index architecture

. That would be loading db record 1,2,3, etc. Would it be faster to load db records mostly sequential: 1,3,4,7,10 compared to randomly: 7,3,10,1,4 -Andy It is called CLUSTER: http://www.postgresql.org/docs/9.2/static/sql-cluster.html Regards, Igor Neyman -- Sent via pgsql-general mailing

Re: [GENERAL] Windows Installation User account - Correct database for us

runs. Using Control Panel you can try to revoke log in local from PostgreSQL account (in Win7 it's actually deny log in local). Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Joining on a view containing a UNION ALL produces a suboptimal plan on 9.3.4

? Is there a simple fix? Thanks! Chris Chris, JOIN tables ON e.col = tables.id - is this a typo? Shouldn't it be JOIN tables ON e.id = tables.id ? Or, you need it the way it is? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

  1   2   3   >