.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
dmin-support@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.
>
pgadmin-support@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_id
Greetings ! It is observed that there are very frequent errors related to
below:"could not receive data from client: Connection reset by peer.
Unexpected EOF on client connection." These are seen heavily in the pg_log
files. some of them are seen as fatal errors and the database gets shutdown
Hello, Greetings !I am new to postgres and recently got migrated from oracle.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 tried to use pg_restore to restore this
10 matches
Mail list logo
