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 CentOS
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 m
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 o
"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
"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
--
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
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
set
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,
though
"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. Th
"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
> N
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 wit
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 probabl
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
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:
http://www.postgresql.org/doc
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
s
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
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 =
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
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
"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 broadcast)---
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 PROT
> --- 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 c
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 perfor
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 acco
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 bet
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 vers
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
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 ad
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
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
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 "autovacuum_analyz
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
>
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 distributi
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
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
"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 somet
"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 (
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
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 tempo
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
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 fr
"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 kn
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 hardware
[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 expr
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
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
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 condit
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 imp
<[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
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 acc
[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) an
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 express
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 funct
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.
I
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
[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 pa
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 responding,
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
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 look
59 matches
Mail list logo
