On Mon, 15 May 2000, Charles Tassell wrote:
I ran into this exact problem, and it was *very* significant on a
15M row table I have. :) It didn't seem to want to use the index, even
freshly created, without a vacuum analyze.
# Have you done a VACUUM ANALYZE on your database after recrea
Hi,
I am new to Postgresql and to SQL as well and I have
the following situation, which has been performed so
far using Codebase Database Manager (xbase standard)
in
several application softwares, using C programming
language:
I have a table with 50.000 records;
I have to display a grid (b
As usual when replying from here, replies prefixed with PM:
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 3
Peter Mount wrote:
>Lamar Owen Wrote:
>> NOTE: There are no Linux/alpha patches in these RPMs. Hopefully, that
>> situation will soon be rectified in a -2 RPMset. However, I _did_ get
>> the 7.0 JDBC jar's in
> PM: Good job I got them done in time wasn't it ;-)
The interesting side of it w
On Tue, 16 May 2000, siva wrote:
> hello,
>
> i'm a web server administrator of clickcricket.com, i was tried to get some
>information on postgres database tools, when i clicked search postgres link; it was
>given me a search.cgi not found error. pls. check this minor mistakes from the major
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > Marten Feldtmann wrote:
> >> The varable lengths columns should be at the end of the row, therefore
> >> it does not seem to be good to add an integer column after a varchar
> >> column.
>
> > 1. Is this true? Should variable length column
On Tue, May 16, 2000 at 01:41:48AM -0700, Dustin Sallings wrote:
> On Mon, 15 May 2000, Charles Tassell wrote:
>
> I ran into this exact problem, and it was *very* significant on a
> 15M row table I have. :) It didn't seem to want to use the index, even
> freshly created, without a vacuum
Two questions:
1. Is there a way to make an "Array field," where you could refer to
something like afield[1], afield[2], . . . and have them each be an
integer or some other base data type?
2. If not, I think something equivalent could be accomplished using
composite data types written in C++
Marcos Barreto de Castro wrote:
>My questions are: Is there a skip function in
> Postgresql that I can use to browse through the
> records in a table forwards and backwards (That table
> has 50,000 records)? If not, how would I be able to
> develop
> such a mechanism as the one explained above
I had the ODBC stuff set up for PostgreSQL 6.* and running it from
within StarOffice5.1 last week. This morning I successfully upgraded to
PostgreSQL 7.0 (goodie for me). Unfortunately I don't know how to
upgrade the ODBC drivers. I have them, I'm just not sure what to do
with them.
To get Pos
Could anyone please tell me what I'm doing wrong? I'm sure I'm just
overlooking something, but what?
==
moran:/acct$ id
uid=1007(postgres) gid=1003(postgres) groups=1003(postgres)
moran:/acct$ export P=/acct/pindybook
moran:/acct$ initlocation P
The location will be initiali
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> On Tue, May 16, 2000 at 01:41:48AM -0700, Dustin Sallings wrote:
>> I ran into this exact problem, and it was *very* significant on a
>> 15M row table I have. :) It didn't seem to want to use the index, even
>> freshly created, without a vacuum a
> # At 04:56 PM 5/15/00, Diego Schvartzman wrote:
> # >I have an application via PHP. For example, a SELECT query that must return
> # >one and only one row, with a where clause with and index (I droped it and
> # >created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
> # >15
I think what you need to do is:
$ initlocation $P
^
$ createdb indybook -D $P
^
-Original Message-
From: Richard J Kuhns [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 8:26 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Question about databases
Richard J Kuhns wrote:
>
> Could anyone please tell me what I'm doing wrong? I'm sure I'm just
> overlooking something, but what?
>
> ==
>
> moran:/acct$ id
> uid=1007(postgres) gid=1003(postgres) groups=1003(postgres)
> moran:/acct$ export P=/acct/pindybook
first guess is
Here are more info. Sorry, I thought taht because this case is very simple,
it was not necesary, but
5 ROWS aprox
QUERY:
SELECT * FROM d_cue WHERE d_cue.clave = '$cue'
INDEX:
create index d_cue_clave on d_cue (clave);
EXPLAIN:
ra1999=> explain select * from d_cue where clave='94
Marcos Barreto de Castro wrote:
>My questions are: Is there a skip function in
> Postgresql that I can use to browse through the
> records in a table forwards and backwards (That table
> has 50,000 records)? If not, how would I be able to
> develop
> such a mechanism as the one explained abov
After my posting last night, the web version of the book was again
unavailable this morning because of server changes.
It is working now:
http://www.postgresql.org/docs/awbook.html
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED]
> On Tue, 16 May 2000, siva wrote:
> > and i also wants to know how to find and delete duplicate values from postgres
>database(primary key not defined). and i dont wants to go thru. any other books or
>reference . give me the correct syntax :
The correct syntax for writing a sentence is to c
Hello all:
Using 6.5.3, SuSE 6.4, logged in as 'billb'.
Here are 2 instances of the COPY command;
-
copy custprofile from '/home/billb/custpr.txt' using delimiters ';';
The result is:
ERROR: COPY command, running in b
This has been answered many times I guess:
My linux filesystem is using a 4k block size. Does this mean that I can only
store up to 4k in a tuple? Where exactly does that 8k limit come from? If
Postgres is limited to 8k per tuple on my system right now, then it would use 2
blocks.
It has been
On Tue, May 16, 2000 at 01:57:19PM -0400, Bill Barnes wrote:
> Hello all:
>
> Using 6.5.3, SuSE 6.4, logged in as 'billb'.
>
> Here are 2 instances of the COPY command;
>
> -
> copy custprofile from '/home/billb/custpr.
Replying to myself in the event that anyone was curious. Ended up
closing down StarOffice and starting it back up. Everything works fine
now. Go figure.
Can't really do/see relationships in Star Office, although that may be
more a StarOffice thing than ODBC driver.
Sam
"Samuel A. Mullen" wr
I would like to ask again, because I feel really stupid, I get no answer. I always
got an answer to my
questions when I mailed in mailing lists until now. What's happening? At least
somebody could answer
simply: "Your question is not worth an answer!" but no answer makes me feel really
stup
24 matches
Mail list logo
