I have libpq client program that repeatedly connects to a DB, queries, and
then disconnects. After a seemingly random number of such successful
sessions (sometimes 30, sometimes hundreds), the backend mysteriously exits
after the client calls PQsetdbLogin(), and the client hangs. Any clues?
On Fri, 10 Oct 2003, Thomas LeBlanc wrote:
> Does a Unique Constraint build a unique index?
>
> What is the difference?
None that I know of.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.post
Quoting Jonathan Bartlett <[EMAIL PROTECTED]>:
> > Ok, I did see the autocommit flag setting in DBD:Pg when I starting reading
> up
> > on the DBI/DBD interfacing methods so I guess I could recode for that.
> However,
> > how do you "maintain" the current transaction open if your script is
> writ
Quoting Doug McNaught <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
>
> > Ok, I did see the autocommit flag setting in DBD:Pg when I starting
> > reading up on the DBI/DBD interfacing methods so I guess I could
> > recode for that. However, how do you "maintain" the cu
> "sm" == scott marlowe writes:
>> will ungracefully kill the DB process(es). Doesn't matter what DB (or
>> any other application) you're running, you *can* lose data this way.
sm> While it is possible to lose a non-committed transaction, WAL prevents the
sm> database from becoming corrupt
Quoting Doug McNaught <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
>
> > I've got a Pg 7.1.3 release that I'm going to upgrade to 7.4 but in the
> meantime
> > I wanted to know if Pg.pm (or DBD:Pg) supported using cursors. I would
> guess
> > that they they don't beca
Jan Wieck wrote:
> > I think the real answer is that until recently, ERserver wasn't open
> > source and we didn't have the option to include it. Now that it is
> > open source, we could think about it. Having looked at the code, I
> > think it's definitely not ready for prime time, but it could
I know \timing counts the time to transfer the data to the client, and I
think log_duration also might have that timing added too. It does seem
like a long time to transfer data, though.
---
Greg Stark wrote:
>
> This quer
> "JL" == Jean-Luc Lachance <[EMAIL PROTECTED]> writes:
JL> BULL.
JL> How many times does PG have to scan the whole table because of MVCC?
JL> At least with partitioning there is a fighting chance that that won't be
JL> necessary.
Huh? His specific query was "WHERE md5 = ''". Why on ea
Is this partitioning like the schemas mentioned here:
http://www.postgresql.org/docs/current/static/ddl-schemas.html? Would those
help and increase performance?
/B
- Original Message -
From: "Jean-Luc Lachance" <[EMAIL PROTECTED]>
To: "Vivek Khera" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTEC
Jean-Luc Lachance wrote:
>
> BULL.
>
> How many times does PG have to scan the whole table because of MVCC?
> At least with partitioning there is a fighting chance that that won't be
> necessary.
> Queries that involve the field on which the table is partitioned execute
> faster by an order of ma
> Absolutely- I was gonna dig into my mod_perl manual since I'm not sure if/how I
> can make the HTML interfaces persist in Apache- I know the backend can (Apache
> <-> Pg) but instead of increasing the complexity of things this time(all the
> script does is write pages of images), I'll see how the
BULL.
How many times does PG have to scan the whole table because of MVCC?
At least with partitioning there is a fighting chance that that won't be
necessary.
Queries that involve the field on which the table is partitioned execute
faster by an order of magnitude.
It also helps with vaccuming as P
Jeff Boes wrote:
Obviously, this is conceptually similar to what the index on the "md5"
column is supposed to do for us. However, partitioning moves just a
little of the processing load off the database server and onto the
machine running the application. That's important, because we can afford
Bruno Wolff III wrote:
The data format change suggested by someone else may be worth trying
as well. In addition to their suggestions, you might experiment with
keeping the hash in either 4 ints or 2 bigints. If you use bigints,
you could probably just use an index on one of the bigints and have
on
> "JB" == Jeff Boes <[EMAIL PROTECTED]> writes:
JB> Will a query against a table of 0.5 million rows beat a query against
JB> a table of 7 million rows by a margin that makes it worth the hassle
JB> of supporting 15 "extra" tables?
I think you'll be better off with a single table, as you won'
This query is odd, it seems to be taking over a second according to my
log_duration logs and according to psql's \timing numbers. However explain
analyze says it's running in about a third of a second.
What would cause this? Is it some kind of postgresql.conf configuration
failure? I have the sam
On Fri, 10 Oct 2003 13:59:38 -0500, "Thomas LeBlanc"
<[EMAIL PROTECTED]> wrote:
>Does a Unique Constraint build a unique index?
Yes.
>What is the difference?
A constraint is an abstract concept, an index is an implementation
detail.
Servus
Manfred
---(end of broadcast)
Okay.I'm following the documentation that came with the PostgreSQL source
code (located in /usr/doc/postgresql-7.3.4-2/html/arrays.hmtl in my cygwin
root).
I created have a table with a varchar array in it, kind of like the
following:
CREATE TABLE tbl_db_usuario_detalles (NOMBRE varchar(50), COD_
Here is my function:
CREATE OR REPLACE FUNCTION public.getLatestInBinsBetween(timestamp,
timestamp, varchar, varchar)
RETURNS SETOF record AS
'
SELECT cmt.binid, cmt.sitename, cmt.exerciseid,
Max(cmt.datetimestamp) AS datetimestamp, max(cmt.issuancetime) AS
IssuanceTime
FROM consolidatedMetRe
On Fri, 2003-10-10 at 12:54, Martin Marques wrote:
> I would like to know what Debian is going to do with PHP and MySQL.
You can raise the issue with Debian's mysql package maintainer
([EMAIL PROTECTED]) and with the mailing list
[EMAIL PROTECTED]
--
Oliver Elphick
Does a Unique Constraint build a unique index?
What is the difference?
Thanks,
Thomas LeBlanc
_
Get a FREE computer virus scan online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-
My experience with mysql and postgres was this. I had some apps that were
running on SQL Server and I wanted to get rid of it because it was
expensive. Didn't really do much for us that the others couldn't, and I
wanted to get rid of windows. Plus administratively SQL Server just seemed
to have
Would you be able to roll your own int1's with types?
http://www.postgresql.org/docs/7.3/interactive/xtypes.html
CSN
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---(end of broadcast)
> Ok, I did see the autocommit flag setting in DBD:Pg when I starting reading up
> on the DBI/DBD interfacing methods so I guess I could recode for that. However,
> how do you "maintain" the current transaction open if your script is writing
> pages to the web. Even in mod_perl I think that there
On Thu, 9 Oct 2003, Vivek Khera wrote:
> > "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes:
>
> SD> Do a shutdown -h on a live database machine with pg. It will
> SD> gracefully shut itself down.
>
>
> I think it is a timing issue. The PG has no way to notify the OS that
> it has fi
Network Administrator <[EMAIL PROTECTED]> writes:
> Ok, I did see the autocommit flag setting in DBD:Pg when I starting
> reading up on the DBI/DBD interfacing methods so I guess I could
> recode for that. However, how do you "maintain" the current
> transaction open if your script is writing pag
Please keep discussions on the list so that others may learn from or comment
on the suggested solutions.
On Fri, Oct 10, 2003 at 11:27:50 -0400,
Jeff Boes <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III wrote:
>
> >On Thu, Oct 09, 2003 at 18:37:19 +,
> > Jeff Boes <[EMAIL PROTECTED]> wrote:
>
On Fri, Oct 10, 2003 at 13:40:17 -0400,
Jeff Boes <[EMAIL PROTECTED]> wrote:
>
> So, again: will front-loading the work by mapping the original query to
> 16 (or 256) different queries by examining the first digit save us
> anything? (My colleague who came up with this idea thinks so, since th
On Fri, Oct 10, 2003 at 04:30:20PM -, [EMAIL PROTECTED] wrote:
> One way to speed things up is to convert the entire checksum. Consider
> what a md5 checksum really is: a text string representing a hexadecimal
> number. Storing it as TEXT or CHAR is not as good as storing it as a
> number d
Bruno Wolff III wrote:
On Fri, Oct 10, 2003 at 11:27:50 -0400,
Jeff Boes <[EMAIL PROTECTED]> wrote:
Yes, the table has:
Table "public.link_checksums"
Column | Type | Modifiers
-+---+---
md5 | character(32) | not null
link_id | integer | not nu
Network Administrator <[EMAIL PROTECTED]> writes:
> I've got a Pg 7.1.3 release that I'm going to upgrade to 7.4 but in the meantime
> I wanted to know if Pg.pm (or DBD:Pg) supported using cursors. I would guess
> that they they don't because from what I understand every executed query in this
>
32 matches
Mail list logo