k write cache." says it all.
If this applies to raid based cache as well then performance is going to
completely tank. For users of Linux + PostgreSQL using LVM.
Joshua D. Drake
>
> .TM.
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Sup
createlang I got the no "root" user message, which is why I
> went to look at initdb. adduser says that postgres user exists, which makes
> sense.
>
I am having a hard time understanding your problem. Why do you have to
recatalog the databases? Why not just createlang -u p
On Fri, 2009-03-13 at 11:41 -0700, Ben Chobot wrote:
> On Fri, 13 Mar 2009, Joshua D. Drake wrote:
>
> >> It seems to me that all you get with a BBU-enabled card is the ability to
> >> get burts of writes out of the OS faster. So you still have the problem,
> &
On Fri, 2009-03-13 at 11:41 -0700, Ben Chobot wrote:
> On Fri, 13 Mar 2009, Joshua D. Drake wrote:
> Of course. But if you can't reliably flush the OS buffers (because, say,
> you're using LVM so fsync() doesn't work), then you can't say what
> actually has m
On Fri, 2009-03-13 at 11:17 -0700, Ben Chobot wrote:
> On Fri, 13 Mar 2009, Joshua D. Drake wrote:
>
> > On Fri, 2009-03-13 at 14:00 -0400, Tom Lane wrote:
> >> Marco Colombo writes:
> >>> You mean some layer (LVM) is lying about the fsync()?
> >>
&
On Fri, 2009-03-13 at 14:00 -0400, Tom Lane wrote:
> Marco Colombo writes:
> > You mean some layer (LVM) is lying about the fsync()?
>
> Got it in one.
>
I wouldn't think this would be a problem with the proper battery backed
raid controller co
e
> nightly back ups, so that decision is mostly out of my hands.
Why not just take a backup of the pitr slave instead? If you need to do
it nightly, shut down the standby process, tar, start standby process.
You never have to bother the master at all.
Sincerely,
Joshua D. Drake
>
&g
>
Alright guys, let's not get into a my elephant trunk is bigger than
yours fight.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving
for a longer, possibly excessively longer
outage. Hard disk space is so darn cheap that it doesn't seem to make
any sense.
Creating indexes concurrently is also out because while you are creating
those indexes your performance will tank because everything is
sequential scanning and there is
years. There's a very good reason we no longer
> do. That suggestion is silly.
*shrug* you can consider it silly. It doesn't change the outcome.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http:/
ad for very little benefit.
Hello,
I am sorry but this seems very silly. If you don't want to back up
indexes use pg_dump.
>
> Any chance of something like this being done in the future?
>
I am going to go out on a limb here and say, "no".
Joshua D. Drake
--
Pos
On Mon, 2009-03-09 at 19:09 -0500, JohnD wrote:
> Joshua D. Drake wrote:
> > What does your listen_addresses say on the affected server? Also just to
> > be safe do a /sbin/iptables -L and make sure you aren't blocking.
> >
>
> Joshua,
>
> Thank you so m
On Mon, 2009-03-09 at 18:11 -0500, JohnD wrote:
> Hi,
> Any idea why I am no longer able to connect?
>
What does your listen_addresses say on the affected server? Also just to
be safe do a /sbin/iptables -L and make sure you aren't blocking.
Joshua D. Drake
> Thanks for
On Fri, 2009-03-06 at 01:09 +0530, Sathish Duraiswamy wrote:
> Can we automate this process , maintained by postmaster itself
No and that would be a bad idea. There has been discussion in the past
of having an IDLE in TRANSACTION timeout but that is a different thing.
Joshua D. Dr
another scheduler package whose authors actually expend
> more than zero effort on working with postgres.
Doesn't pgAdmin have a scheduler?
Joshua D. Drake
>
> regards, tom lane
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development
.
Anyway, I think this is a great thing that you have done as it allows
further exposure to our great project. Good Work.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandpro
Is there a way I can shrink this number (reload the data to consume
> the free space perhaps?)
This is "relations" which means tables, indexes etc... So unless you
start dropping things, no you can't reduce it.
Just increase it a bit (say 20%) it won't hurt you.
Note it
On Fri, 2009-02-27 at 19:06 +0100, Tim Tassonis wrote:
> Joshua D. Drake wrote:
> > On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
> >> Hi all
> >>
> >> I remember, a while ago somebody mentioning an odbc driver for postgres
> >> that
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
> Hi all
>
> I remember, a while ago somebody mentioning an odbc driver for postgres
> that is not dependant on a working postgres client installation.
> Unfortunately I lost the link to it, can anybody remember?
>
ODBCng?
http://projects
On Fri, 2009-02-27 at 01:36 +0100, Alban Hertroys wrote:
> On Feb 26, 2009, at 11:02 AM, Grzegorz Jaśkiewicz wrote:
> You're the one who's asking a question, it's your responsibility that
> we can understand your problem.
Woah... ease up cowboy.
Joshua D. Drake
--
r newest is 8.2.5
> http://www.postgresql.org/docs/faqs.FAQ_german.html
> Basically for all the languages you get a different "lateset"
> release.
>
I can fix the press faq but the others will have to go to the
translators project.
Joshua D. Drake
> Surely these FAQ ent
On Thu, 2009-02-26 at 15:27 -0800, Ron Mayer wrote:
> Joshua D. Drake wrote:
> > On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
> >>
> >> [according to some page on the web site...]
> >> 8.4 was scheduled to be released march 1. Do we know what
;d say that borders on criminal negligence.
I am sure that MoteView's license says otherwise.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
50
On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
>
>
> 8.4 was scheduled to be released march 1. Do we know what the
All schedules are subject to change within the community :)
> tentative date of release is?
When it is done of course.
Joshua D. Drake
--
hive.ini -F %p
This really should be happening on the pitrtools list. Let's bounce over
there and resolve this.
Joshua D. Drake
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The Post
No such file or directory:
> '/var/lib/postgresql/archive/192.168.1.17'
>
> The only time that IP address appears in the INI file is on the slaves
> line, so I'm not sure why it's trying to find a directory called that.
Looks like you didn't run cmd_archiv
>
> Unless I'm just looking for the wrong filename, I still can't fine the
> source RPMs on the yum repo either, just the regular RPMs.
Doh! Yep you are right. Sorry for the noise.
Joshua D. Drake
>
>
> --
> Justin Pasher
>
--
PostgreSQL - XMPP: jdr...@jabb
On Wed, 2009-02-25 at 12:10 -0600, Justin Pasher wrote:
> Is there a reason why the source RPMs for PG 8.1.16 on RHEL don't show
> up here?
>
> http://www.postgresql.org/ftp/binary/v8.1.16/linux/srpms/redhat/rhel-4-i386/
>
> If I cycle through the versions, the last version in the 8.1 branch I
ng to make work. So you will still need pg_standby, rsync, ssh
etc...
I have updated the wiki to make it a bit more friendly.
https://projects.commandprompt.com/public/pitrtools/wiki
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulti
?
You are doing this the hard way. Grab PITRTTools.
https://projects.commandprompt.com/public/pitrtools
Just pull down the stable branch:
svn co
https://projects.commandprompt.com/public/pitrtools/repo/branches/1.2
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
On Wed, 2009-02-25 at 09:44 +0900, Jordan Tomkinson wrote:
>
>
> On Wed, Feb 25, 2009 at 9:23 AM, Joshua D. Drake
> wrote:
>
>
> RAID5 outside of RAID 0 is the worst possible RAID level to
> run with a
> database. (of the comm
On Wed, 2009-02-25 at 09:21 +0900, Jordan Tomkinson wrote:
>
> On Wed, Feb 25, 2009 at 12:05 AM, Aidan Van Dyk
> wrote:
> * Greg Smith [090201 00:00]:
>
> > Shouldn't someone have ranted about RAID-5 by this point in
> the thread?
>
>
>
rect, only the type has an
> invalid owner. I have thus far avoided the temptation to try a manual
> update...
>
> Is there a recommended procedure for resolving this safely?
>
You can use alter type to change the owner of the type to a valid user
but see above. Something is wro
ith !), and to interpret them is equally costly. Do
> you have a suggestion for a better approach?
>
Do you want queries, or transactions? If you want transactions you
already have that in pg_stat_database. Just do this every 10 minutes:
psql -U -d -c "select now() as time,sum(xact_
On Wed, 2009-02-18 at 19:58 -0800, Mike Christensen wrote:
> I have two questions actually..
>
> First off, is there a way to remove a database if the postgres.exe
> service won't start? It seems if I just delete the data\base\x
> directory, then postgres will crash. Is there a way to drop
eased as
> Open Source, and AFAICS it looks more suitable for our needs then
> Slony-I (we are going to replicate the whole DB). I'm I wrong on this?
Well that would depend on your needs I guess. Slony-I is a fine if
complicated system. I would suggest popping over the the
replicat
On Wed, 2009-02-11 at 18:01 +, Adrian Klaver wrote:
> - "Joshua D. Drake" wrote:
> Now I am confused. From the docs I get:
>
My bad. The docs are obviously correct. I think I was thinking about the
postgresql.conf option.
Joshua D. Drae
> SET WITHOUT OIDS
>
rigger, I figured I'd post and find out if anyone
> sees any feet in the way.
That won't drop the OID columns.
Joshua D. Drake
>
> Cheers,
> Steve
>
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4
On Tue, 2009-02-03 at 18:44 -0500, blackwater dev wrote:
> I need to return all rows in a table where one of the columns 'name'
> is 37+ characters. In postgres, is there a function to get the length
> of the columns contents?
>
http://www.postgresql.org/docs/8.3/static/functions-string.html
len
y. There have
been more than one blog post on this.
Our lack of partitioning :)
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
-
postgres=# create table test_trunc(fname varchar(2));
CREATE TABLE
postgres=# insert into test_trunc values ('fo');
INSERT 0 1
postgres=# insert into test_trunc values ('foo');
ERROR: value too long for type character varying(2)
postgres=# insert into test_trunc values ('foo&#
e real-time
> tracking, i want to insert the data in let say every one minute
Feed the data to a loop that waits every 60 seconds. You could also pipe
it to a named pipe while an injector was listening.
Joshua D. Drake
>
> --
> View this message in context:
> http://www.nabb
On Fri, 2009-01-16 at 22:09 -0800, johnf wrote:
> I'm using python and can execute standard "select,update,delete,functions".
> What I'd like to do is execute a sql script (a text file). But I don't know
> how?
You need to open the text file and pass it as an argument:
try:
file = "%s/%
ling list. Most of them make sure
geeks like us, *EAT*.
Does that mean they are not intelligent or perhaps that there talent set
is just different?
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-
in a email?
http://www.american.edu/econ/notes/htmlmail.htm
http://www.georgedillon.com/web/html_email_is_evil.shtml
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The P
ng HTML altogether in
> your emails to this list.
>
> It makes it look as if you are not just shouting, but SCREAMING at the
> top of your lungs! :-)
The answer to this is to not allow HTML email at all to your client. It
is the first thing I disable on any family/friend/church mem
SET statement_timeout TO ...
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
not specified, you will
be prompted interactively.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing li
omponent of that. The main job of
the type system is to assist in insuring that your data is correct.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-gene
; (If you want it to be even more pain-free, add a Reply-To:
> pgsql-advocacy header or some such.)
Hmm good point. I didn't think about that idea.
Sincerely,
Joshua D. Drake
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandpro
On Mon, 2009-01-12 at 18:34 -0300, Alvaro Herrera wrote:
> Joshua D. Drake wrote:
> > Hello,
> >
> > It is now 2009 and time for a, "Thanks for all the laughs 2008!"
>
> That's all great, congratulations.
>
> In the future please do not spam multi
new address is:
United States PostgreSQL Association
1767 12th Street
#149
Hood River, OR 97031
Sincerely,
Joshua D. Drake
President
United States PostgreSQL Association (PgUS)
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The Post
would configure:
http://brazil.postgresqlconference.org/
If you are a community looking for such help, please don't hesitate to
ask.
It is my hope that this will put an end to the PgCon debate.
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
50
cc?
Which make?
How about a paste of the error itself?
Joshua D. Drake
>
> Thanks.
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing l
rename all tables and columns to lowercase, in a specified schema?
Sure. Do this :)
\o /tmp/go_to_lower
select 'ALTER TABLE '||'"'||tablename||'"'||' RENAME TO ' ||
lower(tablename)||';' from pg_tables where schemaname = 'public'
On Thu, 2009-01-08 at 15:12 -0500, Josh Harrison wrote:
> Hi,
> Is there any utility like (oracle's dblink etc) that can establish
> connection between oracle and postgres database?
dbi-link
> Thanks
> Josh
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.
have 12-25 connections at once and load and
> throughput are higher than they were before.
Not to disparage pgPool, but we have also had great results with
pgBouncer.
Joshua D. Drake
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com
his is due to my Postgres or JBoss AS configuration for
> database connections?
>
> Any advice will be greatly appreciated.
An explain analyze of the query would be useful.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandpro
es and concentrated on writing installers instead
> so they can slip in some commercial advantage...
As both pgAdmin and the one-click installers are fully open source, I
fail to see how this is reasonable. If you don't like how pgAdmin is
packaged, you can always create your own
s play a role. Everything else is
> just ordinary evolution of software ;-)
>
Heh fair enough.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-ge
right now Postgres-R (just like Replicator)
keeps its own tree that incorporates the PostgreSQL code.
When open sourcing replicator I tried very hard to convince myself and
others that it was merely a "branch" of PostgreSQL. I lost that sale :P
Joshua D. Drake
--
PostgreSQL
Co
On Thu, 2008-12-11 at 19:33 +, Simon Riggs wrote:
> On Thu, 2008-12-11 at 11:29 -0800, Joshua D. Drake wrote:
>
> > > As I said before, if you think something is missing, submit a software
> > > or a doc patch and submit it to peer review. Until then, I think its
&
n't provide everything you need to get log
shipping working and my *ONLY* point was that we should be clear when
people ask, that they will have to roll their own to a degree.
Stop being defensive.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564
On Thu, 2008-12-11 at 17:37 +, Simon Riggs wrote:
> On Thu, 2008-12-11 at 09:14 -0800, Joshua D. Drake wrote:
>
> > I think this statement is misleading. The only thing core contains is
> > the ability to use a bunch of utilities (with the exception of
> > pg_standby
y to the
> docs which are the most accurate source of detail.
I think this statement is misleading. The only thing core contains is
the ability to use a bunch of utilities (with the exception of
pg_standby) that aren't in core to provide log shipping.
Sincerely,
Joshua D. Drake
--
P
On Wed, 2008-12-10 at 21:39 -0700, Scott Marlowe wrote:
> On Wed, Dec 10, 2008 at 8:43 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> > On Wed, 2008-12-10 at 20:41 -0700, Scott Marlowe wrote:
> >> On Wed, Dec 10, 2008 at 7:40 PM, Tim Uckun <[EMAIL PROTECTED]> wrote:
backup just as fast as
you can sync from slony (or replicator or whatever).
Joshua D. Drake
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mail
On Thu, 2008-12-11 at 15:21 +1300, Tim Uckun wrote:
> What happens when I bring the primary back on line. I now want this to
> be primary again and catch up on all the transactions that were sent
> to the secondary. I want the secondary to resume it's backup status.
>
You have to run a new base
standby uses pg_standby to perform various
functions (including things like failover).
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-g
xternal packages. There also seems to
> be support for periodic backups from the primary to the warm standby.
You can. There is a BSD open source project here:
http://projects.commandprompt.com/public/pitrtools
That will help you with your warm standby needs quite a bit.
Joshua D. Drake
Planned yes, guaranteed no and it is still log shipping which means read
only slaves are out (as I recall).
Sincerely,
Joshua D. Drake
> -Will
>
>
>
>
> - - - - - Cisco
> - - - - -
> This e-mail and
it that would be very helpful, thanks!
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Wed, 2008-12-10 at 15:55 -0500, Eric Schwarzenbach wrote:
> Robert Treat wrote:
> > On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
> >
> >> Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
> >> Debian has a much slower release cycle than Ubuntu and is thus
> >>
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
> Using 8.3.3 I am trying to import a CSV file using the following copy
> command.
>
> copy billing.contact from 'c:/export/contact.csv'
> with delimiter as ','
> null as ''
> csv quote as '"';
>
> The following record record causes an error be
On Thu, 2008-12-04 at 13:44 -0300, Gustavo Rosso wrote:
> Please, exists postgres forum in spanish?
http://archives.postgresql.org/pgsql-es-ayuda/
> Thanks
> Gustavo
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL C
On Wed, 2008-12-03 at 16:23 -0500, Jaime Casanova wrote:
> On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> > On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote:
> >> You may have two servers pointed at $PGDATA but at no point can
&g
p
> > server.
>
> Pretty sure you're going to need a full restart -- reload won't cause
> that parameter to be re-evaluated.
You can change archive_command to something like /bin/true and reload.
However you will have to do a full base backup to get postgresql doing
log
he other on but is it possible for load balancing, i mean with
> the two servers active? obviously one of the two should be only for
> reading...
No.
You may have two servers pointed at $PGDATA but at no point can
postgresql be running on both at the same time.
Joshua D. Drake
--
>
> Yea, this is the graph I was looking for; unfortunately it does not
> shed any insight on why things seems busier; 'old age' is starting to
> look plausible. ;-)
It could also be that a lot of work is happening off channel. I know
that many contributors are having th
On Tue, 2008-12-02 at 00:37 -0500, Greg Smith wrote:
> Tom on things that might ruin his tape backups:
>
> "Then of course there are the *other* risks, such as the place burning to
> the ground, or getting drowned by a break in the city reservoir that's a
> couple hundred yards up the hill...Or
iable it is, is completely another story - but still, they are a
> step ahead in that regard.
Depends on your needs, a broken step is worse than a manual one.
Joshua D. Drake
> Now I know why Tom Lane doesn't have a blog :)
>
> --
> GJ
--
PostgreSQL
Consulting, Develop
unt doesn't capture.
>
> If measured in "bytes of the gzipped mbox" it looks like there's a
> *huge* increase of volume on Hackers in the past 3 months - well
> over twice the historical levels; and maybe 4X 2002-2006.
Its because we eliminated the -patches mailing
you get a graph for that list:
> http://pgsql.markmail.org/search/?q=list%3Aorg.postgresql.pgsql-general
>
> Same for -hackers:
> http://pgsql.markmail.org/search/?q=list%3Aorg.postgresql.pgsql-hackers
>
The top "Who sent it" list is very telling. It says, "Paging Tom Lane...
take a
're all getting older.
ouch
> Soon, these pesky whippersnappers will want to twitter their PG
> questions to this list over YouTube.
>
I assume you don't realize that is already happening :P
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2008-11-20 at 21:19 -0800, Joshua D. Drake wrote:
> On Thu, 2008-11-20 at 23:46 -0500, Tom Lane wrote:
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > > I know that my email (I am pretty sure I am subscribed to at least as
> > > many
On Thu, 2008-11-20 at 23:46 -0500, Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > I know that my email (I am pretty sure I am subscribed to at least as
> > many lists as you) has been on a steady incline, especially through
> > -general and
increase right before 2006
and then a small drop off but a constant after that?
I know that my email (I am pretty sure I am subscribed to at least as
many lists as you) has been on a steady incline, especially through
-general and -hackers.
Joshua D. Drake
>
> regard
On Thu, 2008-11-20 at 15:41 +1100, novice wrote:
> omg - how embarrassing.
> so sorry :(
>
I note your name is novice.
Don't sweat it. We are here to help.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
for a dynamic website that uses 100 - 200 queries to
draw a page?
15ms * 200, 3000ms = 3 secs * 2 (both ways) = 6 seconds.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 2008-11-19 at 17:19 +0200, Devrim GÜNDÜZ wrote:
> On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
> > If so can you direct me to "the" website?
Just a tip... 8.4 isn't released... it isn't even beta yet.
>
> Here is yesterday's snapshot:
>
> http://yum.pgsqlrpms.org/srpms/8.4/po
On Tue, 2008-11-18 at 15:28 -0500, Jonah H. Harris wrote:
> On Tue, Nov 18, 2008 at 3:09 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > Oh, and citation needed. I don't remember seeing anything about
> > oracle using indexes as sole storage units back in 8i
>
> Your memory-foo is weak. See ORG
s good to have them review:
http://www-01.ibm.com/support/docview.wss?uid=nas191f301ccd7abae2f862565c2007cf178
Joshua D. Drake
> Thanks for any input. Or please point me online to any resource that
> discusses this kind of info. I could not find any.
>
> PK
>
--
--
Sent via
y.org/
that provides the functionality.
Joshua D. Drake
>
> Regards,
> Enrico
>
> --
> That's one small step for man; one giant leap for mankind
>
> www.enricopirozzi.info
> [EMAIL PROTECTED]
> Skype sscotty71
>
--
--
Sent via pgsql-general mailing list
On Tue, 2008-11-11 at 06:45 -0800, NetGraviton wrote:
> Web Application Engineer - Drupal, PHP, CSS, JavaScript, Postgresql
>
Please use the proper list... pgsql-jobs.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On Mon, 2008-11-10 at 16:35 -0500, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > It seems that there is enough need for this feature, that it has been
> > implemented multiple times -- but most of them will fail in corner
> > cases. Seems an obvious candidate for an in-core func
On Mon, 2008-11-10 at 20:55 +0100, hubert depesz lubaczewski wrote:
> On Mon, Nov 10, 2008 at 11:44:31AM -0800, Joshua D. Drake wrote:
> > Hmm what about just "ls -tu"
> > Which if I am reading the man page correctly sorts by last access time.
>
> which might not b
(easy to change)
> 2. your logs are named in such way that sorting them alphabetically will
> sort them chronologically (i.e. %Y-%m-%d or something similar) (not easy
> to change)
Hmm what about just "ls -tu"
Which if I am reading the man page correctly sorts by last acces
ked the admin
functions and there is currently no easy way to do it. Sounds like an
easy thing to add though.
Joshua D. Drake
> --
> * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
>
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Looking for the latest timestamp or running
> strftime would both work I guess, those just seemed a little heavy (was
> hoping for an "alias"-sized answer) to figure out something that the
> server certainly knows.
>
show log_filename;
?
Then just grab the strftime strin
e user can turn them off. Use
views, functions and GRANT.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
601 - 700 of 2144 matches
Mail list logo
