Richard H wrote:
>
> On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote
> regarding [GENERAL] Fast Inserts and Hardware Questions:
>
> Please bear in mind that you are operating well above anything I do, so
> I'm not speaking from experience.
I appricate the advice in anycase.
> >
When in doubt, try the explain command
Not exactly sure about postgres but in general LIKE can
only use an index in the case of LIKE "Something%"
LIKE "%Something" or LIKE "%Something%"
won't use an index since it would have to scan the entire
index to find all matches.
Alex.
On Wed, 14 Mar
Have you done any benchmarks with a prototype of your application.
Based off of some of the numbers I've been seeing with my testing,
I would not be surprised if a single pIII 1ghz box with a decent disk
(ata 100 or scsi 160) would handle the load you describe and is way
cheaper than some big smp
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> After inserting a few hundred rows, each insert time seems to take longer
> and longer.
This is fixed in CVS as of yesterday.
regards, tom lane
---(end of broadcast)---
TIP 5:
I have the following table, im_contacts:
-
CREATE TABLE im_contacts
(
id int NOT NULL,
contactid int NOT NULL,
CONSTRAINT contacts_contact_valid CHECK (id <> contactid),
CONSTR
On 3/14/01, 8:26:08 AM, Fabien COUTANT <[EMAIL PROTECTED]> wrote
regarding [GENERAL] [Q] post-crash behaviour:
> Hello,
> I don't know if this the right place to post this, please excuse me if
> I'm wrong. I didn't find any clearly appropriate E-mail for this on the
> website (I could not find
Roy Souther <[EMAIL PROTECTED]> writes:
> Can I make direct calls to PostgreSQL server? I have a lot of data to post to
> the local PostgreSQL server. I am wondering if I can connect directly to it
> to post data so I can by pass the extra layers of
> command -> SQL text string -> port -> SQL in
Hi,
Can anyone telle me if and when a LIKE query uses an index? I've compiled
postgres with locale support. Does that have any influence indexes?
thanks,
Alexander Jerusalem
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I am new to this list, forgive me if I do something wrong.
I am writing an application in C++ for Linux to post data to a PostgreSQL
server.
Can I make direct calls to PostgreSQL server? I have a lot of data to post to
the local PostgreSQL server. I am wondering if I can connect directly to it
Orion Henry writes:
> > Since one query can only use one index per table, you should only need the
> > customer_id index, given the queries you listed.
>
> Isn't that was multi-column indexes are for?
>
> I have 100's of customers but millions of database entries. If I have
> to I'll make a tabl
"Creager, Robert S" <[EMAIL PROTECTED]> writes:
> I'm working with 2.5 million records btw. I've narrowed the situation to
> occur when copying to any one of the 5 referring tables (COPY u FROM stdin).
> The backend process which handles the db connection decides that it needs a
> whole lot of me
On 3/14/01, 6:59:18 PM, Shaw Terwilliger <[EMAIL PROTECTED]> wrote
regarding [GENERAL] Case Insensitive CHECK CONSTRAINTs:
> I have a table with a TEXT field called "username". I'd like to retain
the
> case of the data stored here, but I'd like all comparisons to be done
without
> regard to c
On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote
regarding [GENERAL] Fast Inserts and Hardware Questions:
Please bear in mind that you are operating well above anything I do, so
I'm not speaking from experience.
> I am specing out a database for my company and I need some advice.
Thanks, good news.
I'm also pleased to know that the file size limit has been removed with LFS
on Linux 2.4 and I'll give it a try.
/Jonas L.
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> [EMAIL PROTECTED] (J.H.M. Dassen (Ray)) writes:
> > Your o
Hi
I have the windows application works on postgres (ver 6.4) database on suse
In work I recive thies messages ocasionaly, sometimes after 10 minutes or
after 2 houers, no rules.
,,couldn't connect to backend - socket has been closed.''
or
,,no response from backend - socket has been closed''
i want to be able to create a trigger such that when i insert
information in one table, two other tables will also get a value
inserted. when i looked at the documentation for triggers and functions
(which i personally find daunting), i found out about pl/pgsql and
creating functions.
but how do
Jan Ploski writes:
> Hi,
>
> I just checked out 7.1 from CVS and am trying to compile the JDBC driver:
>
> [javac] /home/jpl/pgsql/src/interfaces/jdbc/org/postgresql/Driver.java:199: ';'
>expected
> [javac] return ${major};
> [javac] ^
You should run './configure --with-java' an
On Wed, Mar 14, 2001 at 09:09:33PM +0100, Jan Ploski wrote:
> Hi,
>
> I just checked out 7.1 from CVS and am trying to compile the JDBC driver:
yeah right, next time I configure it --with-java and it'll be fine ;-)
-JPL
---(end of broadcast)---
T
Peter Eisentraut wrote:
>
> Orion Henry writes:
>
> > The indexes will be
> > int8 (primary key)
> > int4 (group number)
> > timestamp (creation date)
> > int4 (customer id)
>
> Since one query can only use one index per table, you should only need the
> customer_id index, given the queries you
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> I have a table with a TEXT field called "username". I'd like to retain the=
> =20
> case of the data stored here, but I'd like all comparisons to be done witho=
> ut
> regard to case. Since all these accesses _should_ be done through database=
> =20
Hi,
I just checked out 7.1 from CVS and am trying to compile the JDBC driver:
[javac] /home/jpl/pgsql/src/interfaces/jdbc/org/postgresql/Driver.java:199: ';'
expected
[javac] return ${major};
[javac] ^
It looks like there are (CVS?) tags in the Java source code which should
be
* Stephan Szabo <[EMAIL PROTECTED]> [010314 11:52] wrote:
>
> I'd guess that making the lower() index unique would possibly work.
>
> On Wed, 14 Mar 2001, Shaw Terwilliger wrote:
>
> > I have a table with a TEXT field called "username". I'd like to retain the
> > case of the data stored here,
Renaud Tthonnart writes:
> Could someone give me some explaination about the metatable(s) of
> PostgreSQL?
> Where is it and is there to find in it?
A good way is to start psql with "-E", it'll then show you the queries
it makes from the metatables when you do things like "\d table".
Dan
--
On Wed, 14 Mar 2001, Michael Fork wrote:
> radius=# SELECT count(*) FROM radacct WHERE age(now(), tstamp) > '6
> months'::interval;
> count
>
> 128378
> (1 row)
>
> -- Up until this points everything makes sense, however what follows
> -- does not
>
> radius=# SELECT count(*) FROM
I'd guess that making the lower() index unique would possibly work.
On Wed, 14 Mar 2001, Shaw Terwilliger wrote:
> I have a table with a TEXT field called "username". I'd like to retain the
> case of the data stored here, but I'd like all comparisons to be done without
> regard to case. Sinc
Orion Henry writes:
> The indexes will be
> int8 (primary key)
> int4 (group number)
> timestamp (creation date)
> int4 (customer id)
Since one query can only use one index per table, you should only need the
customer_id index, given the queries you listed.
> * Is there an OS that is best suite
Can someone tell me what I am missing here...
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
radius=# BEGIN;
BEGIN
radius=# select age(tstamp, now()) from radacct limit 1;
age
--
03:37:08 ago
(1 row)
radius=# select age(now(
On Wed, 14 Mar 2001, Oliver Elphick wrote:
> You could write a rule for each table/column that would substitute
> NULL for ''.
>
> However, the concept is all wrong. NULL means "I don't know what
> this value is". '' means "I know that this value is an empty string".
> Furthermore, having NULLs
Juhan-Peep Ernits <[EMAIL PROTECTED]> writes:
> (select id, mystuff from arraytest where id=1) union (select id, mystuf
> f from arraytest where id=2);
> ERROR: Unable to identify an ordering operator '<' for type '_varchar'
> Use an explicit ordering operator or modify the query
> Is
--- Jonas Lindholm <[EMAIL PROTECTED]> wrote:
> Can a table grow larger than maximum file size ?
> E.g. will PG create an additional file for the table ?
>
> I'm running PG 7.0.3 on Linux where the maximum file size is
> 2GB
The new Linux 2.4 kernel has blown away that file size barrier.
The ne
Robert Korteweg writes:
> I made a list of all the system tables and there columns in an ascii
> file. the only thing i am still missing is the meening of the columns :(
>
> Q: does anyone already have such a file with explanations to each
> column?
> Q: does anyone know if there is a more accura
[EMAIL PROTECTED] (J.H.M. Dassen (Ray)) writes:
> Your options to have >2Gb files on GNU/Linux therefore include
> - switching to a 64bit platform, say Alpha, Itanic or PowerPC64 or
> - switching to a recent (>= 2.1) version of the GNU C library and a recent
> (e.g. 2.4.x) kernel.
However, this
On Wed, Mar 14, 2001 at 12:17:57PM -0800,
keith <[EMAIL PROTECTED]> wrote:
> I am lost. I am a developer, new to Linux and to postgreSQL.
>
> I am trying to install postgreSQL on a linux machine. Every command I try to run
>gives me a command not found error. I cannot seem to do anything. I tr
Everyone,
I'm still trying to get a handle on all of the possible authentication
methods and what combinations will work best for what I need, and what
combinations will work in general. I am having difficulty getting the
"sameuser" parameter to do anything under DBNAME.
# Format:
#
Jan Ploski <[EMAIL PROTECTED]> writes:
> Do I assume correctly that CPU will be the earliest limiting factor
> for a database (if we have a reasonable amount of memory in the box)?
Depends on your query mix. If you have a lot of updates then I'd
recommend spending plenty of money on fast disk dr
Hello,
I don't know if this the right place to post this, please excuse me if
I'm wrong. I didn't find any clearly appropriate E-mail for this on the
website (I could not find the mailing lists page).
I'm working on a project where we are questionning ourselves about the
reliability of PostgreS
Hi:
I'm relatively new here so excuse me if I sound dumb. I need to know if
(I'm pretty sure it is) it is possible to compare an old recorded timestamp
with the current timestamp and if the old timestamp is say 30 days old,
have that entry deleted?
I'm using 7.0.3 if that matters. Oh, and I
- Original Message -
From: keith
To: [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 12:17 PM
Subject: Please Help
I am lost. I am a developer, new to Linux and to
postgreSQL.
I am trying to install postgreSQL on a linux
machine. Every command I try to run gives me a command
Hi,
I made a list of all the system tables and there columns in an ascii
file. the only thing i am still missing is the meening of the columns :(
Q: does anyone already have such a file with explanations to each
column?
Q: does anyone know if there is a more accurate overview than the one on
th
Could it be as simple as:
$sth = $dbh->prepare("INSERT INTO table (row1, row2) VALUES (?, ?)");
if ( $webinput eq "" ) { $webinput = undef ; }
$sth->execute($webinput, $otherstuff);
I don't have Postgres here to test on, but inserting an undef should
translate to a NULL on most any DBD.
Re
Jonas Lindholm <[EMAIL PROTECTED]> wrote:
>I'm running PG 7.0.3 on Linux where the maximum file size is 2GB
That's somewhat misleading. It's more accurate to state that GNU/Linux on
32bit architectures, for some combinations of kernel and C library, has a
maximum file size of 2GB.
Your options t
Of course, depending on the application, this could mean hand-modifying
every script... so my apologies if this was not what you were after ;)
> Could it be as simple as:
> $sth = $dbh->prepare("INSERT INTO table (row1, row2) VALUES (?, ?)");
> if ( $webinput eq "" ) { $webinput = undef ; }
>
Hello,
i want to store my binary data such as Images,PDFs etc. in a database.
In Postgres doesn't exists the data type BLOB.
So i Have to store it an text field, haven't i ?
How long can a text field be?
thanks
---(end of broadcast)---
TIP 1:
Mi nombre es Yanina Manzo, soy estudiante de Ing.
de Sistemas de la Universidad Nacional del Centro. Necesitaria información sobre
bases de datos
Objeto-Relacionales (integridades referenciales,
reglas del negocio etc.)
Desde ya muchisimas gracias.
Disculpen las mole
I am lost. I am a developer, new to Linux and to
postgreSQL.
I am trying to install postgreSQL on a linux
machine. Every command I try to run gives me a command not found error. I cannot
seem to do anything. I tried running all the commands. I tried being the root
user as well as other use
Hello!
The example is the following:
create table arraytest ( id int, mystuff varchar(40)[][]);
insert into arraytest values (1,'{{"a","b"}}');
insert into arraytest values (2,'{{"c","d"}}');
(select id, mystuff from arraytest where id=1) union (select id, mystuf
f from arraytest where id=2
From: "Jan Ploski" <[EMAIL PROTECTED]>
> Hi,
>
> Thanks for all your remarks regarding 7.1's stability. I'm going to get
> it running as our mail/news database backend and come back with bug
> reports ;-)
>
> Another question which comes to my mind: what would be the best way to
> implement a se
Can a table grow larger than maximum file size ?
E.g. will PG create an additional file for the table ?
I'm running PG 7.0.3 on Linux where the maximum file size is 2GB
Thanks
/Jonas Lindholm
---(end of broadcast)---
TIP 4: Don't 'kill -9' the p
Please don't post HTML to mailing lists - it makes quoting difficult.
From: "Kåre Rasmussen" <[EMAIL PROTECTED]>
loading cache ./configure.cache
checking host system type... configure: error: can not guess host type. you
must specify one
Try something like "i586-pc-linux-gnu" but I'm puzzle
(Frequent Access)
If you just have lots of queries in parallel, try replication, and
pick a random server for each connection.
(Complex Queries)
If you absolutely, positively need one query to be executed across all
nodes in the cluster because one machine would just take too long no
matter how b
Daniel A. Melo <[EMAIL PROTECTED]> wrote:
>/usr/lib/gcc-lib/i386-conectiva-linux/2.95.3/include/limits.h:117:
>limits.h: Arquivo ou diretório não encontrado
I'll assume that's "no such file or directory".
>The line 117 from limits.h has:
>
>#ifndef _GCC_NEXT_LIMITS.H
>#include_next ...
>
>What s
Hello,
When large databases, complex queries and frequent access are combined,
the database backend may become a performance bottleneck. This is quite
obvious.
Do I assume correctly that CPU will be the earliest limiting factor
for a database (if we have a reasonable amount of memory in the box)
Hi ALL,
My Configure
"./configure --with-perl --with-odbc"
generated this messages:
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking echo setting...
checking setting template to... linux_i386
checking whether to support locale... disabled
checking whether t
Hi,
Thanks for all your remarks regarding 7.1's stability. I'm going to get
it running as our mail/news database backend and come back with bug
reports ;-)
Another question which comes to my mind: what would be the best way to
implement a search feature for such a database? I know that there are
keith <[EMAIL PROTECTED]> said:
> - Original Message -
> From: keith
> To: [EMAIL PROTECTED]
> Sent: Wednesday, March 14, 2001 3:51 PM
> Subject: Missing Shared Libraries
>
>
> I have finally got PostgreSQL running on a Red Hat Linux machine, mostly because of
>the help of some kind
Thanks all, this fixed my problem and off I go again.
- Original Message -
From: J.H.M. Dassen (Ray) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:36 AM
Subject: [GENERAL] Re: Fw: Missing Shared Libraries
> [Please drop the HTML - this is a mailing list,
I have just downloaded PostgreSQL-7.0.3 and want to install it
on a redhat 6.2 (i386-family). Though the INSTALL-fil claims that it should be
possible to run "configure" without any option, PostgreSQL cannot guess my
hosttype. The following error messages is displayed.
loading cache ./confi
On Thu, 15 Mar 2001 13:11, keith wrote:
> - Original Message -
> From: keith
> To: [EMAIL PROTECTED]
> Sent: Wednesday, March 14, 2001 3:51 PM
> Subject: Missing Shared Libraries
>
>
> I have finally got PostgreSQL running on a Red Hat Linux machine, mostly
> because of the help of some ki
Hi,
Have you put the path /usr/local/pgsql/lib/ in /etc/ld.conf
or in LD_LIBRARY_PATH
Cheers,
PEJAC Pascal
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
59 matches
Mail list logo
