n 29, 2013, at 11:24 AM, bhanu udaya
wrote:Upper and Lower functions are not right choice when the table is > 2.5
million and where we also have heavy insert transactions.
PostgreSQL and SQL Server are completely different. Rules that apply to SQL
Server do not necessarily apply to PostgreSQL
-general@postgresql.org
To: udayabhanu1...@hotmail.com
On Jun 29, 2013, at 11:24 AM, bhanu udaya
wrote:Upper and Lower functions are not right choice when the table is > 2.5
million and where we also have heavy insert transactions.
PostgreSQL and SQL Server are completely different. Rules t
@postgresql.org
To: udayabhanu1...@hotmail.com
On Jun 29, 2013, at 11:24 AM, bhanu udaya
wrote:Upper and Lower functions are not right choice when the table is > 2.5
million and where we also have heavy insert transactions.
PostgreSQL and SQL Server are completely different. Rules that apply to
.at;
> chris.trav...@gmail.com; mag...@hagander.net
> Subject: Re: [GENERAL] Postgres case insensitive searches
>
>
> On 06/28/2013 03:21 AM, bhanu udaya wrote:
> > Hello,
> >
> > Grettings,
> >
> > What is the best way of doing case insensitive se
pgadmin-supp...@postgresql.org
> To: udayabhanu1...@hotmail.com
>
> On Jun 29, 2013, at 3:59, bhanu udaya
wrote:
>
> > Thanks. But, I do not want to convert into upper and
show the result.
>
t; pgadmin-supp...@postgresql.org
> To: udayabhanu1...@hotmail.com
>
> On Jun 29, 2013, at 3:59, bhanu udaya wrote:
>
> > Thanks. But, I do not want to convert into upper and show the result.
>
> Why not? It won't modify your results, just the search condition:
>
&g
ql.org
> Subject: RE: Postgres case insensitive searches
> Date: Fri, 28 Jun 2013 12:32:00 +
>
> bhanu udaya wrote:
> > What is the best way of doing case insensitive searches in postgres using
> > Like.
>
> Table "laurenz.t"
> Column | Type |
Hello,
Grettings,
What is the best way of doing case insensitive searches in postgres using Like.
Ilike - does not use indexes
function based indexes are not as fast as required.
CITEXT - it still taking 600 ms - 1 second on a 2.2 million rows... does not
use index
Collation Indexes creatio
, 2013 at 1:31 PM, bhanu udaya wrote:
Hello,
Greetings.
My PostgresSQL (9.2) is crashing after certain load tests. Currently,
postgressql is crashing when simulatenously 800 to 1000 threads are run on a 10
million records schema. Not sure, if we have to tweak some more parameters of
Hello,
Greetings.
My PostgresSQL (9.2) is crashing after certain load tests. Currently,
postgressql is crashing when simulatenously 800 to 1000 threads are run on a 10
million records schema. Not sure, if we have to tweak some more parameters of
postgres. Currently, the postgressql is config
Greetings !
I have a hierarchy table with two attributes : Parent_ID, Child_ID with the
sample data (can go upto n-level) as below:
ParentID
ChildID
1
3
1
4
3
5
5
6
6
7
I need a query to retrieve all the n level hierarchy when a Child node_i
.
Thanks and Regards
Radha Krishna
> From: laurenz.a...@wien.gv.at
> To: udayabhanu1...@hotmail.com; chris.trav...@gmail.com
> CC: mag...@hagander.net; franc...@teksol.info; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] pg_Restore
> Date: Mon, 21 Jan 2013 15:19:45 +0000
>
&
il.com; chris.trav...@gmail.com
> CC: mag...@hagander.net; franc...@teksol.info; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] pg_Restore
> Date: Mon, 21 Jan 2013 15:19:45 +0000
>
> bhanu udaya wrote:
> > Can you please let me know the procedure for Template. Will it
-0800
Subject: Re: [GENERAL] pg_Restore
From: chris.trav...@gmail.com
To: laurenz.a...@wien.gv.at
CC: udayabhanu1...@hotmail.com; mag...@hagander.net; franc...@teksol.info;
pgsql-general@postgresql.org
On Mon, Jan 21, 2013 at 3:39 AM, Albe Laurenz wrote:
bhanu udaya wrote:
> I tried with
@postgresql.org
On Jan 21, 2013 7:17 AM, "bhanu udaya" wrote:
>
>
> Hello,
> Greetings !
> Thank you for the prompt reply. I have changed the settings as listed below:
> > > shared_buffers = 1024MB
> > > work_mem = 512MB
> > > maintenance_work_mem
ation process. Thanks and
RegardsRadha Krishna > Subject: Re: [GENERAL] pg_Restore
> From: franc...@teksol.info
> Date: Sun, 20 Jan 2013 23:19:44 -0500
> CC: pgsql-general@postgresql.org
> To: udayabhanu1...@hotmail.com
>
>
> Le 2013-01-20 à 23:10, bhanu udaya a écrit :
Hello,
Greetings !
I am new to postgres and recently got migrated from oracle. I am using
postgresql 9.2 version.
I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with
1 lakh rows in each schema. Could take the data dump using pg_dump and it takes
around 40 minutes. I
17 matches
Mail list logo
