Stephen Ince wrote:
I am looking to embed postgres into an application on windows. I am
fine with it being a separate service. Here is what I am looking to do.
Any help would be greatly appreciated.
This is the wrong list to ask this question. Next time try general list.
What you're looking
Hi,
Le mercredi 25 juillet 2007, Bruce Momjian a écrit :
I have added more documentation to try to show how full text search is
used by user tables. I think this the documentaiton is almost done:
http://momjian.us/expire/fulltext/HTML/textsearch-tables.html
I've come to understand
Andrew Dunstan wrote:
I have never heard back on this, AFAIK. If anyone has instructions on
how to manage this please let me know. My current status with MSVC/vista
is still that I can build but not run as an admin user, and run but not
build as a non-admin user. Bleah.
I remember
[EMAIL PROTECTED] wrote:
To sum up, I am looking for a (decently efficient) scheme that is able to
(1) pass arbitrary conditional expressions from WHERE to the executor in a
structure preserving way.
(2) annotate arbitrary expressions with weights that survive on its way from
the parser
On Tue, Jul 24, 2007 at 10:55:50PM +0200, Magnus Hagander wrote:
Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
The attached file removes this by undefing the macros before we include the
kerberos files. But this is perhaps just too ugly to deal with and we
should live with the
Von: Tom Lane [EMAIL PROTECTED]
Yeah, exactly. ExecInitExpr builds an ExprState tree that mirrors the
structure of the Expr tree but contains all the run-time-variable data.
This tree is what's now being passed to ExecQual.
I see, and ExecInitExpr wraps the OpExpr in an FuncExprState.
Is it
Thanks imad,
Von: imad [EMAIL PROTECTED]
It looks like you need a customized version of AExpr Node.
In the backend parser, an AExpr Node is constructed against each given
WHERE expression. You can store the weight along with the expression.
Further, don't forget to upgrade the copy functions
Von: Heikki Linnakangas [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
To sum up, I am looking for a (decently efficient) scheme that is able
to
(1) pass arbitrary conditional expressions from WHERE to the executor in
a structure preserving way.
(2) annotate arbitrary expressions with
[EMAIL PROTECTED] wrote:
Von: Heikki Linnakangas [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
To sum up, I am looking for a (decently efficient) scheme that is able
to
(1) pass arbitrary conditional expressions from WHERE to the executor in
a structure preserving way.
(2) annotate arbitrary
On 7/25/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Why? What are you trying to achieve?
I am implementing a technique that sorts a result set according to weight
annotations in the WHERE.
The query
SELECT * FROM cars
WHERE (cdChanger=1){2}
OR (mp3player=1){1}
would be sorted
[EMAIL PROTECTED] writes:
Why? What are you trying to achieve?
I am implementing a technique that sorts a result set according to weight
annotations in the WHERE.
The query
SELECT * FROM cars
WHERE (cdChanger=1){2}
OR (mp3player=1){1}
would be sorted according to partial
On 7/25/07, Gregory Stark [EMAIL PROTECTED] wrote:
You're trying to do it by annotating the clauses early on in the parse stage,
and then looking at the annotations in the executor. But I think you'll find
that there are too many steps in between those two which risk destroying or
making it
Heikki Linnakangas [EMAIL PROTECTED] writes:
I am implementing a technique that sorts a result set according to weight
annotations in the WHERE.
The query
SELECT * FROM cars
WHERE (cdChanger=1){2}
OR (mp3player=1){1}
would be sorted according to partial conditions that hold.
You
In
http://momjian.us/expire/fulltext/HTML/textsearch-intro.html#TEXTSEARCH-DOCUMENT
it says:
A document is any text file that can be opened, read, and modified.
Is this an openfts docs relic? tsearch2 is not meant to be be reading
out-of-database *files*, or is it?
If it is actually the case
On Wed, 25 Jul 2007, Erikjan wrote:
In
http://momjian.us/expire/fulltext/HTML/textsearch-intro.html#TEXTSEARCH-DOCUMENT
it says:
A document is any text file that can be opened, read, and modified.
OOps, in my original documentation it was:
Document, in usual meaning, is a text file, that
[EMAIL PROTECTED] writes:
Is it possible to store the calculated logical value of certain
expressions, e.g. boolean OpExprs, in their ExprState on a per tuple
basis to reuse them later? (I guess I described some kind of
'condition cache' here.)
No ... what would be the point? If the
Recently I've been involved in or overheard discussions about SMP
scalability at both the PA PgSQL get together and in some list
traffic.
myYearbook.com would ike to make one of our previous production
machines available to established PgSQL Hackers who don't have access
to this level of
If you're interested in using the box, name what you want installed.
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am most comfortable administering from a
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am most comfortable administering from a
security perspective. If this will be a blocker for developers who
Currently, a toast table attached to a temporary table is treated much
as though it were a regular permanent table: accesses to it go through
shared buffers and are WAL-logged. Aside from the obvious performance
penalties, this means that backends may sometimes acquire open file
pointers for
Note it's a 28 disk system, and I can allocate more if needed, but I
was going to use one MSA for internal use.
On 7/25/07, Mark Wong [EMAIL PROTECTED] wrote:
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am most comfortable administering from a
security perspective. If this will be a blocker for developers who
would actually work on it, please let me know.
Gavin M. Roy [EMAIL PROTECTED] writes:
If you're interested in using the box, name what you want installed.
Personally I use Fedora, but that's because of where I work ;-).
I have no objection to some other distro so long as it's one where
other people can duplicate your environment easily (no
Tom Lane [EMAIL PROTECTED] writes:
So I'm thinking it might be time to fix this. After checking the
code, it seems like it'd be a reasonably small patch if we establish
a convention that toast tables for a temp schema pg_temp_nnn are
kept in an associated dedicated schema, named something
Ubuntu server? Slackware? Not a fan of Centos, RHEL or Fedora...
What about on the BSD side of things?
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
If you're interested in using the box, name what you want installed.
Personally I use Fedora, but
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
So I'm thinking it might be time to fix this. After checking the
code, it seems like it'd be a reasonably small patch if we establish
a convention that toast tables for a temp schema pg_temp_nnn are
kept in an
On Wed, 25 Jul 2007, Gavin M. Roy wrote:
Ubuntu server? Slackware? Not a fan of Centos, RHEL or Fedora...
Unless you did a custom intall, using Ubuntu server would expose the
people using your server to the quirks of how the Debian packages for
PostgreSQL differ from other Linux
On Wed, 2007-07-25 at 08:50 -0700, Mark Wong wrote:
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am most comfortable administering from a
security
I wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Maybe what we could do is set higher thresholds for the regression
database with ALTER DATABASE.
That seems to make sense at least as a short-term response.
I tried this, and it crashed and burned:
ERROR: parameter
On 7/25/07, Simon Riggs [EMAIL PROTECTED] wrote:
On Wed, 2007-07-25 at 08:50 -0700, Mark Wong wrote:
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am
On Wed, 25 Jul 2007, Tom Lane wrote:
Gentoo always leaves me wondering exactly what I'm running today,
and I think reproducibility is an important attribute for a benchmarking
machine.
At this point, there's enough performance variations even between
individual Linux kernel releases that I'm
Simon Riggs wrote:
On Wed, 2007-07-25 at 08:50 -0700, Mark Wong wrote:
On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
I'm currently in the process of having Gentoo linux reinstalled on the
box since that is what I am most comfortable administering from a
Greg Smith wrote:
On Wed, 25 Jul 2007, Gavin M. Roy wrote:
Ubuntu server? Slackware? Not a fan of Centos, RHEL or Fedora...
Unless you did a custom intall, using Ubuntu server would expose the
people using your server to the quirks of how the Debian packages for
PostgreSQL differ from
Greg Smith [EMAIL PROTECTED] writes:
Unless you did a custom intall, using Ubuntu server would expose the
people using your server to the quirks of how the Debian packages for
PostgreSQL differ from other Linux distributions.
I doubt we'd be doing much work with the distro-installed version
Greg Smith [EMAIL PROTECTED] writes:
On Wed, 25 Jul 2007, Tom Lane wrote:
Gentoo always leaves me wondering exactly what I'm running today,
and I think reproducibility is an important attribute for a benchmarking
machine.
At this point, there's enough performance variations even between
On Wed, 2007-07-25 at 14:32 -0400, Tom Lane wrote:
Dave Page [EMAIL PROTECTED] writes:
Perhaps RH could donate us a RHEL/RHN licence for this?
I could ask, if there's consensus we want it.
Please.
It sounded like more
people like Debian, though.
Well, if you don't we probably will go
Tom Lane wrote:
I do essentially all my development work with installations that are
--prefix'd to user directories and started/stopped by hand; it's just
a lot easier to manage a pile of different versions that way. Plus
I never need to become root. Not sure how other developers work,
Tom Lane [EMAIL PROTECTED] writes:
Someday we might like to allow this, but it seems to mean inventing a
new GUC context type, which I don't think I want to get into right now.
Another option would be adding an option to initdb to override default config
settings in the postgreql.conf. Then
Simon Riggs [EMAIL PROTECTED] writes:
On Wed, 2007-07-25 at 22:20 +0100, Gregory Stark wrote:
Also, it might let us set up a standby database in the regression
suite which would give us some xlog coverage as well which is a
critical portion of the system the regression suite doesn't test at
On Wed, 2007-07-25 at 22:20 +0100, Gregory Stark wrote:
Also, it might let us set up a standby database in the regression
suite which would give us some xlog coverage as well which is a
critical portion of the system the regression suite doesn't test at
all.
I like that general thought and
Gavin M. Roy [EMAIL PROTECTED] writes:
If RH can sponsor a license of RHEL I'm inclined to go there.
I'm checking into this, but it may take a few days to get an answer
(particularly since I'm planning to take Friday through Monday off).
regards, tom lane
Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Someday we might like to allow this, but it seems to mean inventing a
new GUC context type, which I don't think I want to get into right now.
Another option would be adding an option to initdb to override default config
Greg Smith [EMAIL PROTECTED] writes:
On Wed, 25 Jul 2007, Tom Lane wrote:
The problem I've got with Gentoo is that it encourages homegrown builds
with randomly-chosen options and compiler switches.
It encourages it, but it certainly doesn't require it. Knowing that this is a
NOC machine,
On Wed, 25 Jul 2007, Gregory Stark wrote:
Does gentoo these days have binary packages? source packages do implicitly
require custom builds...
You can install with binaries now so it doesn't take forever to get
started, but the minute you're adding/updating you're going to be
building. The
I just noticed that storage/file/fd.c's FileUnlink() is not referenced
anywhere, and apparently hasn't been since 7.4. This is a good thing
because it doesn't work very well anymore: it's implemented by setting
the FD_TEMPORARY flag and then calling FileClose(), and the recent patch
to log sizes
If RH can sponsor a license of RHEL I'm inclined to go there. Not
that it was offered, but I think Dave's suggestion was Tom could field
that for the box if inclined. If I'm wrong, let me know. If that
can't happen, would people prefer CentOS or Ubuntu Server? The people
I'm most concerned
On Wed, 25 Jul 2007, Tom Lane wrote:
The problem I've got with Gentoo is that it encourages homegrown builds
with randomly-chosen options and compiler switches.
It encourages it, but it certainly doesn't require it. Knowing that this
is a NOC machine, I don't think there's going to be a lot
I'm not sure if this is the right venue for this- if it isn't, I apologize.
But a feature that I'd like to see is the ability to put an 'as' alias
on the target of an update statement.
I find myself often writing statements like:
UPDATE
some_really_long_table_name
SET
col1
--- Original Message ---
From: Tom Lane [EMAIL PROTECTED]
To: Greg Smith [EMAIL PROTECTED]
Sent: 25/07/07, 18:54:50
Subject: Re: [HACKERS] Machine available for community use
Another fairly big issue is that we need to know whether measurements we
take in August are comparable
Tom Lane wrote:
Greg Smith [EMAIL PROTECTED] writes:
On Wed, 25 Jul 2007, Tom Lane wrote:
Gentoo always leaves me wondering exactly what I'm running today,
and I think reproducibility is an important attribute for a benchmarking
machine.
At this point, there's enough performance variations
On Wed, 2007-07-25 at 19:35 +0200, Stefan Kaltenbrunner wrote:
Rats, I've always liked Gentoo. ;)
I'd agree with Tom on that: we need a system that remains the same over
longer periods, not simply a very fast one. I'm OK with Fedora.
fedora is probably not a prime example for stays
Tom Lane wrote:
Gavin M. Roy [EMAIL PROTECTED] writes:
If RH can sponsor a license of RHEL I'm inclined to go there.
I'm checking into this, but it may take a few days to get an answer
(particularly since I'm planning to take Friday through Monday off).
Well if we go RHEL why not CentOS5
Thanks Heikki,
Von: Heikki Linnakangas [EMAIL PROTECTED]
I am implementing a technique that sorts a result set according to
weight annotations in the WHERE.
The query
SELECT * FROM cars
WHERE (cdChanger=1){2}
OR (mp3player=1){1}
would be sorted according to partial
Dave Page [EMAIL PROTECTED] writes:
Perhaps RH could donate us a RHEL/RHN licence for this?
I could ask, if there's consensus we want it. It sounded like more
people like Debian, though.
regards, tom lane
---(end of
One thing to take into account is I dont have physical access to the
box (It is in TX, I am in PA). All installs but Gentoo will be
performed by a well trained NOC monkey. *cough*
On 7/25/07, Dave Page [EMAIL PROTECTED] wrote:
--- Original Message ---
From: Tom Lane [EMAIL
Gavin M. Roy wrote:
One thing to take into account is I dont have physical access to the
box (It is in TX, I am in PA). All installs but Gentoo will be
performed by a well trained NOC monkey. *cough*
iLO ?
Stefan
---(end of broadcast)---
TIP
Tom Lane wrote:
Dave Page [EMAIL PROTECTED] writes:
Perhaps RH could donate us a RHEL/RHN licence for this?
I could ask, if there's consensus we want it. It sounded like more
people like Debian, though.
well a RHEL/RHN licence would not be a bad thing either (and I guess
it's also a fairly
Magnus Hagander schrieb:
I used to have a different patch from Andrew that did part of this, and
more, and conflicted rather badly with it. However, I never got around
to applying that one, and I can't seem to find it anymore.
Andrew -do you recall if you had all this in yours, and is it still
On 7/25/07, Brian Hurt [EMAIL PROTECTED] wrote:
I'm not sure if this is the right venue for this- if it isn't, I apologize.
But a feature that I'd like to see is the ability to put an 'as' alias
on the target of an update statement.
you can do this since 8.2:
59 matches
Mail list logo
