Hello,
i'm a newbie to pgsql (and SQL as well) so please be patient :-)
first, i would like to know all limitations (or call it parameters) of
PostgreSQL 7 (i use 7.0.2). that includes for example, number of
columns in a row, number of rows in a table, number of triggers,
indexes per table. the
Hi Tom,
Tom Lane a écrit :
>
> Unfortunately neither of these plans is likely to be especially speedy
> on ~3 million rows. The index scan will just thrash the disk, unless
> the table has been clustered recently --- and given the deficiencies of
> our CLUSTER implementation, I'd hesitate to re
hi,
i am creating a table and i want to add an auto incrementable field
is that correct?
psql ival << EOF
create table partes (
codigo int not null auto_increment,
usuario varchar(15),
fecha date,
proyecto varchar(30),
horas int4,
trabajo varchar(100),
observaciones varchar(90),
primary
Hello,
any ideas what this message mean?
ERROR: Index 1821202 does not exist
--
Sincerely Yours,
Denis Perchine
--
E-Mail: [EMAIL PROTECTED]
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
--
> I cant speak for PHP, but in perl or in C you have a documented module
> that will handle this things. (in perl its DBD::Pg). You dont need to
> save the text to a file first, you can write directely into the blob.
>
> The principal things are explained in the postgres-programmers-guide
> you c
Marcos wrote:
>hi,
>
>i am creating a table and i want to add an auto incrementable field
>
>is that correct?
>
>psql ival << EOF
>create table partes (
>codigo int not null auto_increment,
^^
should be SERIAL
--
Oliver Elphick
On Jue 09 Nov 2000 07:56, Marcos wrote:
> hi,
>
> i am creating a table and i want to add an auto incrementable field
>
> is that correct?
>
> psql ival << EOF
> create table partes (
> codigo int not null auto_increment,
WRONG. That is not ANSI-SQL. That is MySQL.
Define it as SERIAL, ju
On Thu, Nov 09, 2000 at 09:00:13AM -0300, Martin A. Marques wrote:
> > I cant speak for PHP, but in perl or in C you have a documented module
> > that will handle this things. (in perl its DBD::Pg). You dont need to
> > save the text to a file first, you can write directely into the blob.
> >
> >
A couple of ideas for you:
Experiment with doing the GROUP BY within your code.
Depending on a number of factors, it's sometimes faster.
Experiment with doing the ORDER BY within your code.
I've seen several cases where pulling the data into
memory and sorting there was much, much faster than
ha
> Christian Fritze <[EMAIL PROTECTED]> writes:
> >
> > I'm working on a web based application (using gnuJSP / JDBC)
> > that needs to do queries like
> >
> > SELECT count(textattrib1), text_cat(textattrib1 || ' '), func1(textattrib2)
> > FROM table1 WHERE textattrib2 >= 'foo' GROUP BY textat
Hi -
I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
got the "semget failed" error. Looking in the faq[1] it says I need to
increase the amount allowed in the kernel. It tells me what I need to do,
but my question is what values should I set them to? Is there any way
* Philip Hallstrom <[EMAIL PROTECTED]> [001109 19:12] wrote:
> Hi -
> I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
> got the "semget failed" error. Looking in the faq[1] it says I need to
> increase the amount allowed in the kernel. It tells me what I need to do,
> bu
> * Philip Hallstrom <[EMAIL PROTECTED]> [001109 19:12] wrote:
> > Hi -
> > I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
> > got the "semget failed" error. Looking in the faq[1] it says I need to
> > increase the amount allowed in the kernel. It tells me what I need to
* Philip Hallstrom <[EMAIL PROTECTED]> [001109 20:37] wrote:
>
> > * Philip Hallstrom <[EMAIL PROTECTED]> [001109 19:12] wrote:
> > > Hi -
> > > I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
> > > got the "semget failed" error. Looking in the faq[1] it says I need to
> > >
I'm starting postmaster as follows:
postmaster -i -D /local/db/postgresql/data -d 2 >>! /var/log/postgresql' &
I'd like to use newsyslog (automatically rotates logs) to keep the log
file in check, but I don't know how to tell postmaster to close/re-open
the log file... I'd rather not restart i
15 matches
Mail list logo
