Re: [GENERAL] Index size

On Fri, Dec 9, 2016 at 6:40 PM, Samuel Williams < space.ship.travel...@gmail.com> wrote: > Thanks Kevin, that makes sense. Yeah, I understand the architectural > difference a bit more now. I also read that when you change a column > which is not index, all the indexes for that row need to be

Re: [GENERAL] Looking for an online mentor

On Thu, 8 Dec 2016 19:19:27 -0500 Metare Solve wrote: > Sorry, I got on so many lists yesterday. I'm really not that dense. > > I have absolutely no language programming skills and it is very very > frustrating. I can HTML and that's it. I desperately want to develop >

Re: [GENERAL] Index size

Thanks Kevin, that makes sense. Yeah, I understand the architectural difference a bit more now. I also read that when you change a column which is not index, all the indexes for that row need to be updated anyway. Is that correct? On 7 December 2016 at 05:27, wrote: >

Re: [GENERAL] Is is safe to use SPI in multiple threads?

On Fri, Dec 09, 2016 at 02:37:58PM -0800, Andres Freund wrote: > On 2016-12-09 16:52:05 +0800, Qiu Xiafei wrote: > > 1. Is there a way to use SPI in multi-thread style? > > No. > > > 2. Another option is to use libpq, like normal clients do. Is libpq as > > efficient as SPI? > > No. To give

Re: [GENERAL] Is is safe to use SPI in multiple threads?

On 2016-12-09 16:52:05 +0800, Qiu Xiafei wrote: > 1. Is there a way to use SPI in multi-thread style? No. > 2. Another option is to use libpq, like normal clients do. Is libpq as > efficient as SPI? No. - Andres -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

PostgreSQL 9.5.0.1 Why 9.5.0 and not 9.5.5, which has a LOT of bug fixes ? not saying thats your problem here, it sounds more like sequencing as per Adrian's reply... -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

On 12/09/2016 12:43 AM, thomas.deboben@rohde-schwarz.com wrote: Hello, I need some help on an installation issue with PostgreSQL 9.5.0.1 I have written a wix bootstrapper to install postgresql for our application. This has worked for different version, but now we get sometimes trouble

Re: [GENERAL] Regrding:- Arduino-Postgresql Direct Connection

On 12/8/2016 8:56 PM, Roshan Jha wrote: In my project ,I have to send the data from the arduino to the direct postgresql for storing .So i want know that is it possible to make direct connection between arduino to postgresql ,If yes, then let me know, how should i do. arduinos don't even

Re: [GENERAL] Out of memory error

Chris Roberts writes: > Would someone tell me why I am seeing the following Postgres logs? > 07:56:20 EST LOG: 08P00: incomplete message from client > 07:56:20 EST LOCATION: pq_getmessage, src\backend\libpq\pqcomm.c:1143 > 07:56:20 EST ERROR: 54000: out of memory >

[GENERAL] Is is safe to use SPI in multiple threads?

Hi, buddies! I'm new to PG and want to implement my domain-specific system based on PG. I wish to arrange my data as several tables in database and translate my DSL into SQL statements for query. Since one DSL statement may be mapped to several SQL statements, it's better to push the DSL server

[GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

Hello, I need some help on an installation issue with PostgreSQL 9.5.0.1 I have written a wix bootstrapper to install postgresql for our application. This has worked for different version, but now we get sometimes trouble with the installer as some sql scripts can't be executed during install.

[GENERAL] Regrding:- Arduino-Postgresql Direct Connection

Hi Everyone, In my project ,I have to send the data from the arduino to the direct postgresql for storing .So i want know that is it possible to make direct connection between arduino to postgresql ,If yes, then let me know, how should i do. Thankyou & Regards Roshan

[GENERAL] Out of memory error

Hello, My deployment is Postgres 9.3.5 on a Windows machine. Would someone tell me why I am seeing the following Postgres logs? 07:56:20 EST LOG: 0: execute : SELECT * FROM "c3p0" 07:56:20 EST LOCATION: exec_execute_message, src\backend\tcop\postgres.c:1906 07:56:20 EST LOG: 0:

Re: [GENERAL] Multidimentional array access

On 09/12/16 15:30, Tom Lane wrote: As of 9.6 you could use the shorthand array_value = Eg[i][:] regards, tom lane I hadn't spotted that - very handy - will go and read up on it. :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via

[GENERAL] ora2pg - Java Message Service (JMS) Type

Hi All, We plan to use ora2pg tool to migrate Oracle to PostgreSQL. During the testing, while importing content of the output.sql into PostgrSQL database, it terminated with the following error "ERROR: type "aq$_jms_text_message" does not exist" for "user_data" column with

Re: [GENERAL] SELECT slow immediately after many update or delete+insert, except using WHERE .. IN

On 12/09/2016 08:03 AM, Tom DalPozzo wrote: > Hi, > I did two tests: > TEST 1 > 1 I created a table ("Table") with two fields, one ("Id") is a bigint > and the other ("Data") is a bytea. Also created an index on Id. > 2 Populated the table with 1 rows, in which the bigint is > incremental and

[GENERAL] SELECT slow immediately after many update or delete+insert, except using WHERE .. IN

Hi, I did two tests: TEST 1 1 I created a table ("Table") with two fields, one ("Id") is a bigint and the other ("Data") is a bytea. Also created an index on Id. 2 Populated the table with 1 rows, in which the bigint is incremental and bytea is 1000 bytes long. 3 Executed SELECT COUNT(*) FROM

Re: [GENERAL] storing C binary array in bytea via libpq

On Wed, Dec 7, 2016 at 4:10 AM, Tom DalPozzo wrote: > Hi, > I tried both ways: they're ok. > Also, multiple VALUES in one INSERT is actually better as performance. If you are chasing performance with the binary protocol you might want to take a look at libpqtypes:

Re: [GENERAL] Multidimentional array access

VENKTESH GUTTEDAR writes: > I want to get the inner array in a multi dimentional array in a > pl/pgsql procedure. > Eg : {{1,2,3,4,5,6,7},{11,22,33,44,55,66,77}} > for i in array_lower(Eg, 1) .. array_upper(Eg, 1) > LOOP > array_value = Eg[i]

Re: [GENERAL] When to use COMMENT vs --

On Wed, Dec 7, 2016 at 9:57 AM, Rich Shepard wrote: > I have used '-- ' to enter comments about tables or columns and am curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? Main

Re: [GENERAL] Multidimentional array access

Hi 2016-12-09 16:05 GMT+01:00 VENKTESH GUTTEDAR : > Hello, > > I want to get the inner array in a multi dimentional array in a > pl/pgsql procedure. > > Eg : {{1,2,3,4,5,6,7},{11,22,33,44,55,66,77}} > > for i in array_lower(Eg, 1) .. array_upper(Eg, 1) >

[GENERAL] Multidimentional array access

Hello, I want to get the inner array in a multi dimentional array in a pl/pgsql procedure. Eg : {{1,2,3,4,5,6,7},{11,22,33,44,55,66,77}} for i in array_lower(Eg, 1) .. array_upper(Eg, 1) LOOP array_value = Eg[i] END LOOP; But Eg[i] is assigning null to

Re: [GENERAL] Unexplained statistics reset? Help tracking it down.

On 12/09/2016 06:19 AM, Bill Moran wrote: I've been seeing some unexplained behavior whereas the statistics in a Postgres database reset with no explanation as to why. This is concerning because it results in terrible query plans until someone manually runs analyze, and that it negatively

[GENERAL] Unexplained statistics reset? Help tracking it down.

I've been seeing some unexplained behavior whereas the statistics in a Postgres database reset with no explanation as to why. This is concerning because it results in terrible query plans until someone manually runs analyze, and that it negatively impacts autovacuum. This is Postgres 9.5.4 on

Re: [GENERAL] How to loop through multi-dimentional array in PL/PGSQL

On 09/12/16 10:42, Raymond O'Donnell wrote: On 09/12/16 06:35, VENKTESH GUTTEDAR wrote: Hello, Please help me in accessing multi-dimentional array in postgresql PL/PGSQL. for i in array_lower(product_list, 1) .. array_upper(product_list, 1) LOOP product_list[i][0]; END

Re: [GENERAL] How to loop through multi-dimentional array in PL/PGSQL

On 09/12/16 06:35, VENKTESH GUTTEDAR wrote: Hello, Please help me in accessing multi-dimentional array in postgresql PL/PGSQL. for i in array_lower(product_list, 1) .. array_upper(product_list, 1) LOOP product_list[i][0]; END LOOP; Is the above code right? Or

[GENERAL] Re: [ADMIN] Would like to below scenario is possible for getting page/block corruption

Hi Sreekanth, I doubt auto-recover of the page might be possible, as the header of the page is no more valid & corrupted and not sure whether the corruption occurred in relation of a data or index block. We have seen some occurrences like this before which got rectified by performing reindexing

Re: [GENERAL] After upgrade to 9.6: waiting column does not exist

On 9 December 2016 at 10:13, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > > On 09/12/2016 10:04, John R Pierce wrote: > > are you running some sort of monitoring software thats periodically > looking at pg_stat_activity ? whatever query its doing needs to be > rewritten to take

Re: [GENERAL] Looking for an online mentor

On Fri, Dec 9, 2016 at 8:58 AM, Karsten Hilbert wrote: > > > Historian - diligently research what you don't know and don't > know you don't know > > The one thing cross access people typically don't bring in is > strong set-related skills. Maybe you can get a

Re: [GENERAL] After upgrade to 9.6: waiting column does not exist

On 09/12/2016 10:04, John R Pierce wrote: On 12/8/2016 11:59 PM, Johann Spies wrote: Now, when running the 9.6 server the following error message shows up regularly in the log: postgres@template1 ERROR: column "waiting" does not exist at character 217 As far as I understand the following

Re: [GENERAL] After upgrade to 9.6: waiting column does not exist

On 12/8/2016 11:59 PM, Johann Spies wrote: Now, when running the 9.6 server the following error message shows up regularly in the log: postgres@template1 ERROR: column "waiting" does not exist at character 217 As far as I understand the following remark in the release notes, the column

[GENERAL] After upgrade to 9.6: waiting column does not exist

We did a pg_upgrade from 9.5 to 9.6 Now, when running the 9.6 server the following error message shows up regularly in the log: postgres@template1 ERROR: column "waiting" does not exist at character 217 As far as I understand the following remark in the release notes, the column 'waiting'