Is there a collation for case and accent insensitive filter? I just found the
use of operators like ILIKE ou CITEXT module but I can't use ILIKE in the
queries and the CITEXT is a field-by-field solution for the case insensitive
part of the problem. I also found the unaccent text search dictiona
_id,tag_id)
);
But I would really like to avoid doing that.
Is there a solution to this problem with arrays of foreign keys, and
if so, how does one do that?
Thanks for any help.
Max
---(end of broadcast)---
TIP 5: don't forget to increase
I
did some research in the online doc. It's a cool functionality, but
what's the performance of it?
Would using an array_accum slow down a view?
Thanks
Max
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ssue behind all this fuss is an identity
problem: does postgresql want to play side-by-side with the big database
players and have an official, legal and legitimate newsgroup, or does it
want to stay in the closet ?
Max
---(end of broadcast)---
TI
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Andrew Rawnsley
> Sent: Thursday, November 11, 2004 12:26 PM
> To: Pgsql General
> Subject: Re: [GENERAL] comp.database.postgresql.*
>
>
>
> On Nov 11, 2004, at 1:56
Because it's Right, because it makes us closer to Standards, because
> to be respected means to respect others. Etc, etc. etc.
Nicely put ;)
This is exactly what I was trying to say.
Max
---(end of broadcast)---
TIP 8: explain analyze is your friend
>
> [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
>
> >>The other issue is that I would like to add the other postgresql
> >>groups for consideration to be included into the big 8. However there
> >>are quite a few of them, and I don't know if all of them deserve to be
> >>there. They are all
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Bill Harris
> Sent: Monday, November 29, 2004 9:50 PM
> To: Marc G. Fournier
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...
>
>
> "Marc G. Fournier"
igits.
What are our options ?
I am a little bit ignorant in this part of RDBM. Can we distribute our
tables across multiple servers (read server+postgres) and perform
distributed SQL queries ? If so, how does that work ? I am totally
resourceless!
Thank you in advance
utes, and
the rest of the time we were too slow.
>
>
> On Jan 26, 2005, at 11:00 AM, Max wrote:
>
> > Hello,
> >
> > Our postgresql database is getting too big to be handled by one
> > server. We
> > need the database to be in RAM and cannot afford swapping.
r load - but I
> haven't actually used it, so can't give any advice...
thanks, I am going to look into this.
>
> Hope that helps.
>
> John Sidney-Woollett
>
> Max wrote:
> > Hello,
> >
> > Our postgresql database is getting too big to be handled
subscribe
end
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
n on q (cost=0.00..12.50 rows=1000 width=32)
-> Index Scan using idxfti_idx2 on posts_index
i (cost=0.00..4891.27 rows=1227 width=253)
Index Cond: (i.idxfti @@ "outer".q)
Any suggestions?
Regards,
Max
---(end of broadcast)
Hi,
At 09:54 PM 1/27/2005, you wrote:
On Thu, 27 Jan 2005, Max wrote:
I'm setting up a simple search engine using Tsearch2.
The basic idea is: a user enters a search query and a maximum of 1000
results is returned, sorted by date, newest first.
At the moment the table holding the searchable
what do you think the cost would be for such a beast ? Any idea ?
Max
---(end of broadcast)---
TIP 8: explain analyze is your friend
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> Sent: Friday, January 28, 2005 4:02 AM
> To: Max; PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> On Thu, 27 Jan 2005 20:17:29 -
Opteron MBs but whether that's because
> those specs were done before >= 4GB DIMMs were available or an actual
> hardware limitation, I dunno.)
>
Thank you! That's very thorough. hm... we're talking 35K then. That could be
in my budget.
>
>
>
> Max wrote:
> >&
y forecast the growing curve. My bet is that we have a short
term (6 months) need of 32 GB, so I'll just double that and it should give
us visibility for about a year. I hope!
I just realized I never asked that question: What is the maximum size of a
postgresql DB. Can it be anything ?
Max
---
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> > Sent: Friday, January 28, 2005 4:02 AM
> > To: Max; PgSql General
> > Subject: Re: [GENERAL] Splitting queries across servers
> >
&g
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> Sent: Saturday, January 29, 2005 11:01 AM
> To: Max
> Cc: PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> On Sat, 29 Jan 20
; advisable. All the
> other options like grsec et al are nice but require careful thinking,
> propolice just needs to be activated. If you don't know what it is I'll
> post docs.
>
I have never heard of Propolice SSP. What is it ? Any relation to the honey
'Propolys&#x
AE.
>
What's PAE ?
Here's a question for the developers: what's the memory consumption
difference when you move a 3GB database from a 32 bit machine to a 64 ?
given that the whole thing must be in RAM.
Isn't the whole data taking up more RAM because point
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of PFC
> Sent: Saturday, January 29, 2005 1:25 PM
> To: Max; PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
>
> > I have never heard o
an external function.
How could I write this ?
Thx for help.
Max
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
(ROW.perm_field2))
statement
/* ... */
RETURN TRUE or FALSE;
/* ... */
Or am I obligated to pass to my function the tablename and the id
field to execute a second query, then retrieving the row fields and
then computing permissions and then returning true or false ?
Thx for Help
Max
On Fri, 3 Aug 2007 at 19:09, Jorge Godoy wrote:
> Having updated packages would be great! Specially if they would be
> updated for, e.g., OpenSuSE 10.1 and OpenSuSE 10.2 (both already
> released) and not just for OpenSuSE 10.3 (still under
> "development").
Yes, that's why I created the /pub/p
Hello.
I have a web-server with php 5.2 connected to postgres 8.0 backend. Most
of the queries the users are doing are SELECTs (100-150 in a second for
100 concurrent users), with a 5-10 INSERTs/UPDATEs at the same time. There
is also a demon running in the background doing some work once e
On Thu, 23 Aug 2007 08:29:03 +0400, Tom Lane <[EMAIL PROTECTED]> wrote:
"Max Zorloff" <[EMAIL PROTECTED]> writes:
... The problem is that after the number of concurrent users rises to
100, CPU becomes almost 100% loaded. How do I find out what's hogging
the
CPU?
On Thu, 23 Aug 2007 12:24:32 +0400, Hannes Dorbath
<[EMAIL PROTECTED]> wrote:
On 23.08.2007 11:04, Max Zorloff wrote:
When one postgres process waits for lock to release does it use any cpu?
And also, when apache waits for query to finish, does it use cpu?
No, but are you sure what y
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database through pg_pconnect(). Then it
runs some query, then the script returns, leaving the persistent
connection hanging. But the trouble
is that in this case any query t
On Thu, 23 Aug 2007 21:16:48 +0400, Joshua D. Drake <[EMAIL PROTECTED]>
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database t
On Thu, 23 Aug 2007 21:29:46 +0400, Bill Moran <[EMAIL PROTECTED]>
wrote:
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
> Hello.
>
> I have a subject setup and a few questions.
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the system. I've set num_init_children to 5 and
here is the top output.
One of postmasters is my demon running some insert/update tasks. I see
that they all use cpu heavily,
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the syste
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
shared_memory is used for caching. It is filled as stuff is used. If
you're not using all of it that means it isn't need
Hello. I'm using Apache + PHP + Postgres for my project. I've tried the
two poolers people
usually recommend here - pgbouncer and pgpool.
I have a problem with pgbouncer - under the load the query execution
becomes ~10 times slower
than it should be - basically to test it, I connect with psql
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]> wrote:
The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just "hangs", and if I try to connect to it with psql it just hangs
indefinitely. After restart
it works fine a
On Sat, 08 Sep 2007 19:28:52 +0400, Scott Marlowe
<[EMAIL PROTECTED]> wrote:
On 9/7/07, Max Zorloff <[EMAIL PROTECTED]> wrote:
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]>
wrote:
>> The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2)
Hi, all.
I was wondering, can I really declare a 2-dimensional array of arbitrary
size in pl/pgsql?
According to the docs it seems that only way would be to declare it as
something like :
myArray := ARRAY[[1,2], [3,4], [5,6]];
But what if I pass the dimensions as function parameters?
My po
On Thu, 29 Nov 2007 18:11:22 +0400, Rodrigo De León <[EMAIL PROTECTED]>
wrote:
On Nov 29, 2007 3:34 AM, Max Zorloff <[EMAIL PROTECTED]> wrote:
According to the docs it seems that only way would be to declare it as
something like :
myArray := ARRAY[[1,2], [3,4], [5,6]];
You
On Thu, 29 Nov 2007 19:21:03 +0400, Pavel Stehule
<[EMAIL PROTECTED]> wrote:
Hello
arrays in PostgreSQL have to be regular allways. And before 8.3 array
cannot contais NULL, so you cannot simpl resize two dim array :(. But
your functions doesn't work in 8.3. too. So you can
a) use 1D array a
On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <[EMAIL PROTECTED]>
wrote:
On Nov 29, 2007 9:33 AM, Max Zorloff <[EMAIL PROTECTED]> wrote:
I don't think that works.
ponline=# select ('{1,2,3}'::text)::int[];
ERROR: cannot cast type text to integer[]
Ca
appreciate any feedback you might have.
I am very new to PostgreSQL and this mail list. Please let me know if I did not
something wrong.
Thank you.
Regards,
Max
Hi David,
Thanks for suggestion. We use PostgreSQL 9.5. And we did not import or bulk
loaded data to these tables.
Regards,
Max
-Original Message-
From: David Rowley [mailto:david.row...@2ndquadrant.com]
Sent: Monday, 1 May 2017 11:05 PM
To: Max Wang
Cc: pgsql-general@postgresql.org
Hi Adrian,
Only sequences (id) reset to 1.
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, 1 May 2017 11:30 PM
To: Max Wang ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On 04/30/2017 10:51
Hi Amitabh,
Thank you for suggestion. We did not reach the limit of serial type. Some
tables only have hundreds of rows.
Regards,
Max
From: Amitabh Kant [mailto:amitabhk...@gmail.com]
Sent: Monday, 1 May 2017 7:58 PM
To: Max Wang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] all
Sorry. I mean all tables’ id column were reset to 1.
Thanks.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Tuesday, 2 May 2017 9:14 AM
To: Max Wang
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On Mon, May 1, 2017 at 7
Hi Adrian,
I checked and found
is_cycled | f
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:16 AM
To: Max Wang ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On 05/01/2017
Hi Amitabh,
I mean the serial sequence that controls the id value has been set to 1 for all
tables. That's why I got the duplicate key value error when I tried to insert
the new record to table.
Thanks.
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adria
increment_by | 1
max_value | 9223372036854775807
min_value | 1
cache_value | 1
log_cnt | 29
is_cycled | f
is_called | t
Regards,
Max
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Tuesday, 2 May 2017 9:49 AM
To: Adrian Klaver
Cc: Max Wang ; Amitabh Kant ;
pgsql
Hi Adrian,
Thank you. The strange things is we only use Python do insert/update/delete
and do not run other SQL command.
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:55 AM
To: Max Wang ; pgsql-general
1000/1000
tps = 2799.134267 (including connections establishing)
tps = 2799.451407 (excluding connections establishing)
Any input? I can reproduce these numbers consistently. By the way, I am a new
postgresql user so my experience is limited.
Cheers,
Max
No one has had this problem??? Should I perhaps direct this to the developers
list?
Cheers,
Max
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Max Williams
Sent: 03 June 2010 14:22
To: pgsql-general@postgresql.org
Subject: [GENERAL] Performance
:21:49 dbs1 postgres[20866]: [2-2]FROM "XYZ123" AS "T0"
Jun 28 10:21:49 dbs1 postgres[20866]: [2-3]WHERE ("T0"."Id" = $1)
I'd like to log or find out what $1 was from the postgresql server side, not
the application side. Is this possible?
Best Regards,
Max Williams
I'm running 8.4.4 so you are saying this should work?
I don't really want to go to debug level logging, tried it for 5 mins and it
just logs too much!
Max
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 28 June 2010 15:28
To: Max Williams
Cc: pgs
Hello everyone.
I'm working on a small project of mine, which basically revolves
around messages.
These messages are to be ordered in a very standard fashion of single-depth
threads. That is, a message can be a reply, and a so-called "head".
A head is simply the head of a chain. To put it more e
Hey, thanks for your quick response
On Wed, Feb 11, 2009 at 12:00 AM, Sam Mason wrote:
> On Tue, Feb 10, 2009 at 11:19:13PM +0100, Max Strrrmberg wrote:
>> [...] messages are to be ordered in a very standard fashion of single-depth
>> threads. That is, a message can be a reply,
On Sun, 9 Oct 2005 at 18:59, Devrim GUNDUZ wrote:
> On Sun, 9 Oct 2005, Tom Lane wrote:
>
> > Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > > I've been using SuSE and PostgreSQL for a fairly long time.
> > > Recently (last 12 months), I've noticed that the 9.x (9.2 and
> > > 9.3 specifical
On Tue, 11 Oct 2005 at 21:57, Gregory Youngblood wrote:
> SuSE 10 is the "commercial" release from Novell. It contains
> additional packages not in the opensuse.org open source version.
> There is an eval cd and dvd set that can be downloaded of the
> "commercial" release - though I do not beli
Hi!
error with Subquery alias...
help...
SELECT *,(SELECT COUNT(id)
FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depth
FROM articles
where (depth < 3)
ORDER BY lft
Max mailto:[EMAIL PROTECTED]
---(end of
iable. Does it really happen (coercion)? Is
the int8 value automatically converted into int2, or
an error should be returned in that case?
Thanks in advance
Max Ueda
Do you Yahoo!?
Everyone is raving about the al
value.
But, when I've changed this (setting the variable type
to int8), it worked as I expected.
Thank you!
Max Ueda
--- Filip RembiaÅkowski
<[EMAIL PROTECTED]> wrote:
> 2007/1/16, Max Ueda <[EMAIL PROTECTED]>:
> > Hi,
> >
> > I've been wondering w
I recognize the value of working with people who love what they do, that is why
I am looking into the open source community. I am a statistician so I have no
idea about how to find good OSS programmers. Any suggestions are welcomed.
A quantitative hedge fund within Lazard Asset Management in N
regarding the RPM packages. Feedback for PostgreSQL itself should of
course go to the usual channels of the project.
Reinhard Max
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unreg
Dear Mr., My name is Chia. I'm a Malaysian student who still persuing my computer course. Now I'm working with a IT company for industry training. I got some questions about server. 1.) What I knew is when too many users access a database at the same time, it will slow down database
of 800k.
Of course I need to try out different scenarios, I need to run 2 queries
instead of one for example and so on.. But I guess it will show once I
understand better how to build the functions I belive I need.
Thanks in advance,
Max!
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
sorry, forget this: it was my fault, now the function works also on pg8.
anyway, it is strange that i can do this with c functions and not with
plpgsql ones...
m.
max jacob wrote:
hallo,
i am using pg7.3.4. i have written a table function in c that
tokenizes a text, returning a setof text. i
forseen behavior for using a
set returning function in the field list of a select and, if the answer
is "it should raise an error", if it is possible to work around it?
thanks in advance,
max.
ps: i did not subscribe the mailing list, so please use "replay all"..
-
#x27;
bill=#
So, how can I explain that resulting type must be boolean ? Also, I try to
play with SELECT INTO with same result.
--
... All opinions expressed are mine and not those of my employer.
Yours, Max [Msg N 2419]
--
text'/'int2' they work fine.
I guess the problem is that PL/pgSQL doesn't handle opaque type correctly.
Any ideas ?
I don't care how but I need to emulate ENUM type, just to convert MySQL dumps to
PostgreSQL. E.g. ENUM values
stored in MySQL dump should be restorable in Postgres without any conversion.
I running PostgreSQL 7.0.3 on Linux RedHat 6.2, kernel 2.2.15, Intel Celeron CPU;
Postgres was
upgraded from 7.0.2 without changing anything in system catalog.
Thanks,
Max Rudensky.
olutely need it - but it shure would be handy.
Cheers: Max!
both insert and update
statements, but during many insert in contact table sequence's nextval may be used by
concurrent transactions, so one of them will be rolled back.
I prefer to do it with PL/pgSQL, anyway I can't use C.
Any ideas ?
Thanks,
Max Rudensky.
Hi,
We are using PostgreSQL 8.2.x and like to upgrade to 8.3.x. So I downloaded
and installed the Win32-Binaries.
This happens with shell scripts that I had to modify because it seems that
the ODBC driver isn't included anymore (checkes 8.3.0 and 8.3.1). Also the
module msvclibs isn't available.
Tom Lane wrote:
Jean-Max Reymond <[EMAIL PROTECTED]> writes:
3. datestyle="Postgres, European" in the postgresql.conf file, but
unfortunately it does nor work
I think you need single quotes in that file. Try
datestyle='Postgres, European'
sorry, but it do
Tom Lane wrote:
Jean-Max Reymond <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I think you need single quotes in that file. Try
datestyle='Postgres, European'
sorry, but it does not work with simple or double quotes :-(
Works for me (with single quotes). Did
Oliver Elphick wrote:
On Wed, 2003-12-10 at 23:01, Jean-Max Reymond wrote:
I stop the postmaster (/usr/local/pgsql/bin/pg_ctl stop) and restart the
postmaster (/usr/local/pgsql/bin/pg_ctl -D /home/local/BasePostgres/ -l
logfile -o -i start).
I have tried with and without blanks near
76 matches
Mail list logo
