Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

PostgreSQL has been successfully compiled in netbeans 8.1. But how to add its extension PG_Strom into it? -- View this message in context: http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p5931427.html Sent from the PostgreSQL - general mailing

[GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Considering PGStrom, an extension of PostgreSQL-9.5.4, I tried opening that file in netbeans 8.1 I opened PGStrom in netbeans as File -> New Project -> C/C++ -> C/C++ Project with Existing Sources. And then selected the Folder that contains existing sources (PG_Strom). And then Finish It is

Re: [GENERAL] variable value in array_to_string

For what its worth: DO $$ DECLARE vresult text; begin EXECUTE $qry$ WITH cols (c) AS ( VALUES ('col1'),('col2') ) SELECT string_agg('a.' || cols.c, ',') FROM cols WHERE 'foo' = $1 $qry$ USING 'foo' INTO vresult; RAISE NOTICE '%', vresult; END; $$; I still haven't actually figured out

Re: [GENERAL] variable value in array_to_string

1 - I added some new notes. 2 - That code I know and works fine. I used it in slightly different contexts in other projects Here it is a case . A table with two columns , data type is irrelevant I have a need in which I may get a.col1,a.col2 and other variations Point is yes I could build

Re: [GENERAL] variable value in array_to_string

Please don't top-post - it makes following the thread a lot harder. On Mon, Nov 21, 2016 at 4:15 PM, Armand Pirvu (home) wrote: > Played with unnest but not much luck > If you want help you will need to show your work - ideally with examples that can execute with

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

On Mon, Nov 21, 2016 at 11:22 AM, Poul Kristensen wrote: > Thank you for fast repons! > > The $1 substitution below. I assume that it refers to "joe's place". But > it is not very clear to me, how "joe's place" will appear instead of $1 > when running. Where is it possiible to

Re: [GENERAL] Database migration to RDS issues permissions

Hi Adrian, I followed you link and I had again errors: pg_restore: [archiver (db)] Error from TOC entry 4368; 2606 151317 FK CONSTRAINT type_id_3940becf ownersuser pg_restore: [archiver (db)] could not execute query: ERROR: constraint "type_id_3940becf" of relation "store" does not exist

Re: [GENERAL] variable value in array_to_string

Played with unnest but not much luck NOTICE: {item_id,show_id} NOTICE: item_id It takes only the first array element in consideration Ug On Nov 21, 2016, at 5:02 PM, Armand Pirvu (home) wrote: > My bad on the back tick. No idea why it turned that way > > OK

Re: [GENERAL] variable value in array_to_string

My bad on the back tick. No idea why it turned that way OK got that David. The idea is that I have the pk columns in an array which I would like to manipulate from the array itself rather than running same query variations multiple times For example I get in foo {item_id,show_id} And from

Re: [GENERAL] variable value in array_to_string

On Mon, Nov 21, 2016 at 3:09 PM, Armand Pirvu (home) wrote: > Hi > > Is there anyway I can pass a variable in the array_to_string function ? > > ​Yes, just like you can pass variables to any other function.​.. > CREATE OR REPLACE FUNCTION test1 () RETURNS void AS $$ >

[GENERAL] variable value in array_to_string

Hi Is there anyway I can pass a variable in the array_to_string function ? CREATE OR REPLACE FUNCTION test1 () RETURNS void AS $$ DECLARE foo text; foo1 text; begin execute 'select ARRAY( SELECT d.COLUMN_NAME::text from information_schema.constraint_table_usage c,

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

On Mon, Nov 21, 2016 at 11:34 AM, dhaval jaiswal wrote: > Due to business impact auto vacuum is off. You have now discovered some of the the negative business impact of turning it off. If you leave it off, much worse is likely to follow. -- Kevin Grittner EDB:

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

dhaval jaiswal wrote: > Adding to above. Below are the outputs. I just meant that you need to ANALYZE all these system catalogs so that autovacuum can pick up vacuuming them to remove dead tuples. Do not leave autovacuum turned off anymore. -- Álvaro Herrera

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

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of dhaval jaiswal Sent: Monday, November 21, 2016 12:35 PM To: Kevin Grittner ; Alvaro Herrera Cc: Adrian Klaver ; David G.

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

Adding to above. Below are the outputs. select count(*) from pg_stat_sys_tables where n_tup_ins =0 ; count --- 326 (1 row) select count(*) from pg_stat_sys_tables where n_tup_upd =0 ; count --- 358 (1 row) select count(*) from pg_stat_sys_tables where n_tup_del =0 ;

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

On Mon, Nov 21, 2016 at 10:34 AM, dhaval jaiswal wrote: > Due to business impact auto vacuum is off. > ​You won't get much sympathy if you turn this feature off. The question you should be pondering is how to properly configure ​it for your environment. ​pg_class gets

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

dhaval jaiswal wrote: > I did check and found it was the bloated size of pg_class which was slowing > down the performance. > > It got fixed by adding in routine maintenance task. Things are fine now. Good to know. > However, I want to know how come pg_class (system table) get >

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

I did check and found it was the bloated size of pg_class which was slowing down the performance. It got fixed by adding in routine maintenance task. Things are fine now. However, I want to know how come pg_class (system table) get bloated/affected. What could be the possible ways, where i

Re: [GENERAL] Partial update on an postgres upsert violates constraint

On 11/21/2016 02:32 AM, Andreas Terrius wrote: Is there any way to check whether the row already exists before checking constraints ? I still want it to fail if it turns out to be a new row (which would violate the not null constraint), but updates the row if it already exists. Since if that is

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

On Mon, Nov 21, 2016 at 8:56 AM, Poul Kristensen wrote: > Hi! > > Hopefully this is this list. > > A shell variabel is defined like this > > var1= value > > used like ${var1}. > > How is the equal defened in the Postgresql C programming? > > Thanks. > > Poul > > BTW: I have

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

On 11/21/2016 06:56 AM, Poul Kristensen wrote: Hi! Hopefully this is this list. A shell variabel is defined like this var1= value used like ${var1}. How is the equal defened in the Postgresql C programming? You probably need to be more specific about what aspect of using C in Postgres

Re: [GENERAL] How to introspect autovacuum analyze settings

On 21 November 2016 at 14:57, Guillaume Lelarge wrote: > 2016-11-21 14:44 GMT+01:00 Benedikt Grundmann : > >> Hello all, >> >> I have a quick question. I feel like somewhere in section 23.1.6 there >> should be the answer but I couldn't find it

Re: [GENERAL] How to introspect autovacuum analyze settings

2016-11-21 14:44 GMT+01:00 Benedikt Grundmann : > Hello all, > > I have a quick question. I feel like somewhere in section 23.1.6 there > should be the answer but I couldn't find it yet. Namely how can I query > the database for total number of tuples inserted,

[GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

Hi! Hopefully this is this list. A shell variabel is defined like this var1= value used like ${var1}. How is the equal defened in the Postgresql C programming? Thanks. Poul BTW: I have not received my ordered book yet!

Re: [GENERAL] How to introspect autovacuum analyze settings

On 11/21/2016 05:44 AM, Benedikt Grundmann wrote: Hello all, I have a quick question. I feel like somewhere in section 23.1.6 there should be the answer but I couldn't find it yet. Namely how can I query the database for total number of tuples inserted, updated, or deleted since the last

[GENERAL] How to introspect autovacuum analyze settings

Hello all, I have a quick question. I feel like somewhere in section 23.1.6 there should be the answer but I couldn't find it yet. Namely how can I query the database for total number of tuples inserted, updated, or deleted since the last ANALYZE?

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

What are the functions (for example) are available/not available to get transformed to GPU source code? What is the factor value u consider to get multiplied with actual cost for CPU? For example, default cpu_tuple_cost is 0.01. Consider, for example, if the cost=0.00..458.00 for seq scan, how

Re: [GENERAL] [HACKERS] How to change order sort of table in HashJoin

Thanks for reply, sir. On 11/21/2016 1:39 AM, Tom Lane wrote: Man writes: Additional information. In 9.6 the second table (lesser tuple) was choosen (the same testdata). There are something (cost estimation?) different in previous versions. I'd bet on different