Hello,
Our PG runs on Ubuntu boxes and it's 9.3.4, thinking of upgrading to 9.3.12 or
9.5.2.
Is the normal approach of upgrade something like below, no matter if it's major
version or minor version upgrade? My focus is on pg_dump at the moment.
#1 pg_dump
Dump DB
Apt-get update
Apt-get install
Hi,
We have the requirement of using the data type tsvector [], however, I didn't
find out how to:
* Use array operator together with tsquery operator
o I have to unnest the array and then do query like "ts@@ to_tsquery('ipod')"
* Create GIN index on tsvector[]
o ERROR: d
Hi,
It's my test DB, the version is PostgreSQL 9.4beta2. I'm testing with nested
hstore feature.
testdb=# \d+ test
Table "public.test"
Column | Type | Modifiers | Storage | Stats target | Description
++---+--+--+
-Original Message-
From: Peter Geoghegan [mailto:peter.geoghega...@gmail.com]
Sent: Monday, August 25, 2014 12:14 PM
To: Huang, Suya
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type
On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya wrote
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Huang, Suya
Sent: Monday, August 25, 2014 12:18 PM
To: Peter Geoghegan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, August 25, 2014 11:42 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type
On 08/24/2014 07:05 PM, Huang, Suya wrote:
> Hi,
>
>
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, August 26, 2014 11:58 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type
On 08/25/2014 06:05 PM, Huang, Suya wrote:
> -Origi
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, August 27, 2014 12:42 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type
On 08/26/2014 06:50 PM, Huang, Suya wrote
Instead of deleting from the original non-partition table which is not
efficient, you can try below approach.
Put below logic in a function as you like:
Create a new partition table.
Insert data from original non-partition table to the correct partition of new
partition table.
Build index and a
renamed to the same name as the old table, it should be ok.
Note, it’s tested in my 9.3 environment, not sure how it behaves in older
versions…
From: Herouth Maoz [mailto:hero...@unicell.co.il]
Sent: Wednesday, September 10, 2014 6:26 PM
To: Huang, Suya
Cc: pgsql-general@postgresql.org
Subject: Re
Has anyone tried the OPM? I followed the installation instruction and in the
end I got a blank web page...
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of damien clochard
Sent: Tuesday, September 09, 2014 1:23 AM
To: p
Thank you Damien, issues updated. https://github.com/OPMDG/opm-core/issues/2
-Original Message-
From: damien clochard [mailto:dam...@dalibo.info]
Sent: Thursday, September 11, 2014 5:36 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Introducing Open PostgreSQL
That’s a good idea, thanks for sharing Herouth!
From: Herouth Maoz [mailto:hero...@unicell.co.il]
Sent: Tuesday, September 16, 2014 10:22 PM
To: Huang, Suya
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] (Solved) Decreasing performance in table partitioning
Thank you. My solution is
It seems like it's not been sent to the SQL group, so I'm trying with this
group.
Thanks,
Suya
From: Huang, Suya
Sent: Friday, December 05, 2014 6:25 PM
To: 'pgsql-...@postgresql.org'
Subject: [SQL] rolling window without aggregation
Hi SQL experts,
I've got a questi
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: Monday, December 08, 2014 1:18 PM
To: pgsql-general@postgresql.org
Subject: Re: FW: [GENERAL] SQL rolling window without aggregation
Huang, Suya
Hi,
OK, first, I know the reason of this error "index row size 3040 exceeds btree
maximum, 2712" and know that we cannot create index on certain columns with
size larger than 1/3 buffer page size.
The question is, no matter if I deleted records that caused the problem or all
records of the tab
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tomas Vondra
Sent: Tuesday, October 15, 2013 7:09 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] werid error"index row size 3040 exceeds btree maximum,
2712" occur randomly
Hi,
On 14.10.2013 05:47, Huang,
Hi,
I've got a question of converting database from ascii to UTF-8, what's the best
approach to do so if the database size is very large? Detailed procedure or
experience sharing are much appreciated!
Thanks,
Suya
pgsql-general@postgresql.org
Subject: Re: [GENERAL] werid error"index row size 3040 exceeds btree maximum,
2712" occur randomly
On 15.10.2013 03:44, Huang, Suya wrote:
> Thanks Tomas!
>
> However, in the example I sent, I already did a vacuum full right
> after deleted the r
database character set ?
On Oct 17, 2013, at 3:13 PM, "Huang, Suya" wrote:
> Hi,
>
> I've got a question of converting database from ascii to UTF-8, what's the
> best approach to do so if the database size is very large? Detailed procedure
> or experienc
Forgot to mention, we're using a very old version which is 8.3.11.
I'll take a look at the guide for 8.3 with similar section.
Thanks Adrian!
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Friday, October 18, 2013 3:05 PM
To: Huang, Suya; St
org
Subject: Re: [GENERAL] [ADMIN] what's the efficient/safest way to convert
database character set ?
On 10/17/2013 3:13 PM, Huang, Suya wrote:
> I've got a question of converting database from ascii to UTF-8, what's
> the best approach to do so if the database size is very large
o:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Friday, October 18, 2013 4:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] [ADMIN] what's the efficient/safest way to convert
database character set ?
On 10/17/2013 9:49 PM, Huang, Suya wrote:
> Yes John,
@postgresql.org
Subject: Re: [GENERAL] [ADMIN] what's the efficient/safest way to convert
database character set ?
On 10/17/2013 10:51 PM, Huang, Suya wrote:
> Question: How can I pull out the real character set information from the
> database? does it rely on the understanding of busines
> We stored ISO-8859-1, do we still need to use iconv to convert the file?
you should be able to do the dump specifying pg_dump
--encoding=iso-8559-1 then restore it to the utf8 database, and postgres will
do the conversion for you.
One more question, if the data stored in database including UTF
Hi,
I've encountered a weird problem in PostgreSQL :
postgres=> create user test password 'test';
postgres=> grant select on pg_catalog.pg_database_size to test;
postgres=> grant execute on function pg_catalog.pg_database_size(name) to test;
--login as user test
postgres=> select current_user;
Thank you Tom and Albe. After grant connect database privilege to user test,
the query runs without problem.
Thanks,
Suya
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, May 08, 2014 12:13 AM
To: Albe Laurenz
Cc: Huang, Suya; 'pgsql-general Ge
27 matches
Mail list logo
