On Wed, Jul 18, 2007 at 11:30:48AM -0500, Scott Marlowe wrote:
> EnterpriseDB, a commercially enhanced version of PostgreSQL can do
> query parallelization, but it comes at a cost, and that cost is making
> sure you have enough spindles / I/O bandwidth that you won't be
> actually slowing your syst
On Wed, Jul 18, 2007 at 11:02:51PM +0100, Richard Huxton wrote:
> Francisco Reyes wrote:
> >As far as I know, currently one can set the search path globally, or on
> >a per role bases.
> >
> >I was wondering if it could be possible to have a per database search_path.
> >I believe this would be not
ocation to another on the
HD? I'd like to use slony to minimize downtime, but I'd also like my
data to end up in the same place it is right now when I'm done.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed
On Sun, Feb 27, 2005 at 09:27:41PM +0100, Tino Wildenhain wrote:
> Hi,
>
> Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> > On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > &
On Mon, Feb 28, 2005 at 09:27:46PM +0100, Martijn van Oosterhout wrote:
> On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote:
> > > I used a straight copy of the filesystem with running database
> > > (over the net in my case) and immediately after that,
> >
st('1 month'::interval AS seconds);
ERROR: cannot cast type interval to seconds
\dC shows that the cast is there, and rrs.interval_to_seconds works as
expected, and according to \df does return seconds.
Version is 7.4.5.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
On Fri, Mar 04, 2005 at 03:40:17PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > decibel=# create cast (interval as rrs.seconds) WITH FUNCTION
> > rrs.interval_to_seconds(interval) AS IMPLICIT;
> > CREATE CAST
> > decibel=#
opers
who might have been interested in working to improve PostgreSQL now that
it runs on windows.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux
On Wed, Mar 09, 2005 at 11:39:53AM -0600, Doug Hall wrote:
> On Wed, 9 Mar 2005 11:02:10 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> >... but the fact is there's still a LOT of places
> > that are windows shops and a LOT of people who use windows more heavily
>
" it's more: "we believe this platform is better
> than others, so we'll write our free software for that. But if you want to
> port it over to the platform of your choice, have fun doing that."
With the attitude of "Windows can not be made to reliably run a
datab
On Wed, Mar 09, 2005 at 05:51:43PM -0800, Chris Travers wrote:
> Jim C. Nasby wrote:
> Ok--- I will admit to a anti-Windows bias. But at least my bias is
> informed. In addition to my former employment at Microsoft, I have
> studies both types of OS's in detail. Here
hese problems? I've seen several people
mention things like this in passing, but I have yet to see any
specifics.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go
nse to the more popular
> >GPL.
> >
> >
>
>Fine I can't see the difference, but have you not got to clear this
> with every developer past and present to get it through.
Nope. You can do anything you want with BSD licensed software, so long
as you maintain the c
t;sound"
> complete with out them. Regardless if you can download them separately.
> People are lazy. They don't want to download them separately.
>
> I see those as:
>
> plPgsql (for Oracle people)
> plPerl
> plPHP
What databases support perl or php stored pr
MySQL is generally only quicker if you don't care about your data
(MyISAM tables) and if you aren't hitting it with multiple clients.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "
On Sun, Apr 03, 2005 at 08:41:15PM -0700, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
>
> >On Sat, Apr 02, 2005 at 07:29:02AM -0800, Joshua D. Drake wrote:
> >
> >
> >>This argument doesn't hold too much weight. Namely because there are only
> >>3
> Use the elog() function. :)
See also
http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go
On Thu, Apr 14, 2005 at 11:05:37PM -0400, Joseph Shraibman wrote:
> Incidentally when I did that I only got back one row. What's up with that?
That's PostgreSQL acting according to ANSI SQL. If you want multiple
rows, you need UNION ALL.
--
Jim C. Nasby, Database Consultant
cement
for SELECT max(blah):
SELECT max
FROM (SELECT blah FROM table ORDER BY blah DESC LIMIT 1) a
;
Maybe not a great example since you'll only get one row back, but the
point is that the ORDER BY in the subquery doesn't mean a thing when it
comes to output order.
--
Jim C. Nasby, Da
---
> TIP 7: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Li
s
> (i.e. rollback).
>
> Thanks for the help,
> -- C
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
on=l.id)
OR EXISTS (SELECT * FROM andu a WHERE a.location=l.id)
OR EXISTS (SELECT * FROM idu i WHERE i.location=l.id)
This query would definately be helped by having indexes on
(pa|andu|idu).location.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your
op of other sequential scans. See the quote "For
petabyte-scale databases, the only solution may be to run continuous
data scans, with queries piggybacked on top of the scans." on page 4.
There's also been discussion about how to more intelligently cost UDF's,
something also menti
it
> have the commercial backing like PostgreSQL.
Support it in what way? Do they allow for parallel query execution?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go to
ough hopefully it'll get built into 8.1)
the index views should get you pretty close to what you need for
generating index definition statements. If there's anything missing let
me know.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy!
sn't covered by an
index.
> My apologies if this has been answered before, but a search of the
> -general mailing list was not fruitful.
FYI, often times new ideas are only discussed on -hackers, so you should
search there as well.
--
Jim C. Nasby, Database Consultant [E
nsert. Can the query planner also use then
> somehow?
It can use them the same way it can use any other index.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go toda
t)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy!
ed up hash joins?), if
there's no plans to fix them they should still be removed. If someone
ever really wanted to do something with, the code would still be in CVS.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net T
On Tue, May 10, 2005 at 02:38:41AM +1000, Neil Conway wrote:
> Jim C. Nasby wrote:
> >Having indexes that people shouldn't be using does add confusion for
> >users, and presents the opportunity for foot-shooting.
>
> Emitting a warning/notice on hash-index creation is s
bly you don't want to
re-write the entire index every time it looks like a different bucket
size would help.)
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go toda
On Tue, May 10, 2005 at 10:14:11AM +1000, Neil Conway wrote:
> Jim C. Nasby wrote:
> >> No, hash joins and hash indexes are unrelated.
> >I know they are now, but does that have to be the case?
>
> I mean, the algorithms are fundamentally unrelated. They share a bit of
mind. But it's impossible to really make a recommendation
without having a better idea of what you're doing.
BTW, my understanding is that it's pretty easy to write a daemon in
perl, and there are examples of how to do this floating around.
--
Jim C. Nasby, Database Consultant
On Tue, May 10, 2005 at 11:49:50AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > What's the challange to making it adaptive, comming up with an algorithm
> > that gives you the optimal bucket size (which I would think there's
>
e you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux
zabo=# select power(0.1::numeric, 17);
>power
>
> 0.
> (1 row)
>
> sszabo=# select power(0.1::numeric, 17)*100;
> ?column?
>
> 0.00000000
> (1 row)
>
>
>
MAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "
; >__
> >Do You Yahoo!?
> >Tired of spam? Yahoo! Mail has the best spam protection around
> >http://mail.yahoo.com
>
>
> ---(end of broadcast)-----------
> TIP 7:
On Fri, May 20, 2005 at 01:03:08PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Why are we allowing implicit casts from numeric to floating point?
>
> Because the SQL spec requires it.
>
> 2) If the data type of eit
of the owner of the tables I
> should query to. How to manage this ? Can I use a parameter
> to define the table owner ? A macro ? Is there any
> solution?
>
> Thanks a lot.
>
> Jayme.
>
> - Original Message -
> From: "Jim C. Nasby"
> To: Jayme
synonyms for the tables and by pass the format
> above, or I can use a macro substitution (ODAC components) to use the
> correct schema name, setting it at runtime.
In PostgreSQL, you can get roughly the same behavior using search_path.
http://lnk.nu/postgresql.org/2r2.html
> By t
or the Global Internet. Keep this in mind if you answer this message.
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL
ing you might want to consider is MySQL's disregard for data
integrity. Try stuffing 'xx' into a varchar(1) some time and see what
happens. That's just one example; http://sql-info.de/mysql/gotchas.html
has a pretty complete list.
--
Jim C. Nasby, Database Consultant
nd didn't
cost a fortune they could probably make a good amount of $$ with it.
BTW, I believe some of the really high-end database tools will do what
you're looking for, but those typically start at a couple grand or more.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED
ses (one with the old schema, one
with the new) and have some tool compare the two and generate a diff and
a patch file. Of course it might not catch everything (such as droping a
column and then re-adding it with the same definition), but it would
work fine in 99.99% of the cases.
--
Jim C. Na
existence of a
> particular version of the function? I can query
> information_schema.routines for the function name, but not for the
> particular parameters.
If you're specifically worried about functions, why not just use CREATE
OR REPLACE?
--
Jim C. Nasby, Database Consultant
ode out right now that might be a tad 'safer', as there
might be some users who are using it but don't read the mailling lists.
Has Kerb4 been marked as depricated in the docs at all? If not it might
be best to just do that and then yank it later.
--
Jim C. Nasby, Database Consultan
ay if something is considered depricated and will be
removed in the future. Having said that, that statement means it's
removal shouldn't come as a shock to anyone.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.n
ne compile it.
This is why I put very little faith in certifications; all that they
prove is that you know how to pass some test.
Tell me this, does knowing any of the info in this question really make
you a better PostgreSQL admin or user, other than #1? I would consider
#2-4 to be trivia, and as
ave to have one server online (with
Why do you think that's the case?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to g
On Mon, Jun 27, 2005 at 01:05:42PM -0700, Dann Corbit wrote:
>
> > -Original Message-
> > From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> > Sent: Monday, June 27, 2005 12:58 PM
> > To: Dann Corbit
> > Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
>
hen rename
> when completed.
Interesting idea, though the problem is that AFAIK everything will block
on the rename. If everything didn't block though, this might be a better
way to do it, although it potentially complicates the code greatly
(think about needing to add indexes, re
ce should
> read "So that leaves Postgres". Your problem is solved ;-)
>
> (If you are accustomed to Oracle, you are probably expecting an ACID
> database, which rules out MySQL too).
But there's no need to take our word for it... just google for &#x
a
Not on todo:
Estimate gains from not using the in-memory format of data for on-disk
storage
Estimate gains from reducing the amount of space used by visibility
information in each tuple
BTW, what ever happened to the idea of having a list of projects for
beginners? (Or maybe it'd be better
On Thu, Jul 14, 2005 at 11:29:23PM +0200, Martijn van Oosterhout wrote:
> On Thu, Jul 14, 2005 at 11:30:36AM -0500, Jim C. Nasby wrote:
> > On Wed, Jul 13, 2005 at 07:52:04PM -0400, Bruce Momjian wrote:
> > > This is a good point. We have always stored data on disk that exactly
On Sat, Jul 16, 2005 at 03:18:24PM -0700, Ron Mayer wrote:
> Jim C. Nasby wrote:
> >On Thu, Jul 14, 2005 at 11:29:23PM +0200, Martijn van Oosterhout wrote:
> >>On Thu, Jul 14, 2005 at 11:30:36AM -0500, Jim C. Nasby wrote:
> >>>On Wed, Jul 13, 2005 at 07:52:0
een talk of
creating a list of good TODO items for new coders to tackle, but I don't
think that ever happened.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
h one has different alignment constraints. The point
is that I don't know of any database that will silently re-order fields
under the covers to optimize storage.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team
s that it doesn't get you some of the in-memory benefits
that field ordering will get you, but I suspect in most cases the
on-disk gains will swamp those out anyway.
Does anyone have any idea what it would take to hack in divorcing disk
page layout from memory layout just for testing?
--
Jim
re's enough interest. If you want to discuss specifics,
-hackers is probably a better place.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Wher
yvalue text NOT NULL
> );
>
> Primary Key:
> ALTER TABLE ONLY conceptproperty
>ADD CONSTRAINT conceptproperty_pkey PRIMARY KEY (codingschemename,
> conceptcode, propertyid);
>
> Thanks,
>
> Dan
>
> ---(end of broadcast)---
data.
>
> I would be thankful for any information and experiences in this field of
> application.
PostGIS has it's own email list as well as other support options; you
should try those out.
http://postgis.refractions.net/support/
--
Jim C. Nasby, Database Consultant [E
claiming it (and asking for any clarification, etc), and dive in.
If you're interested in internals or new feature development you should
absolutely subscribe to -hackers. Have I emphasised -hackers enough yet?
:)
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your c
top working...
Wait, are you saying your database server is swapping? You'll never get
any kind of performance if that's the case.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: &qu
reSQL?
They should be as readily supported as signed, right? I don't think
these would even have to be in core, if that's a concern.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: &q
le of some kind. But, on the
up-side, it's also possible that it could allow for minimal downtime
migraitons to take place in the future (of course adding that support
would take a lot of work, but theoretically it's possible).
--
Jim C. Nasby, Database Consultant [EMAIL PROT
On Fri, Jul 29, 2005 at 03:57:48PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Is there any serious impediment to adding unsigned types to PostgreSQL?
>
> Quick, what's the datatype of 12345? And why?
>
> My guess is that
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go
t overflows
1/0 = NULL
count(*) is an approximation
easy to configure in such a way that it's not ACID
...
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go t
foundry.org/projects/pgjob/. It's in
> the planning stages.
Actually, it's currently in the going nowhere stage since no one's
expressed any interest in it. Anyone who's interested is encouraged to
join the mailing list and post what they'd like to see from the project.
-
;s not very easy to do because
2 of the catagories are over 9 items long (humans deal with info best in
chunks of 5-9 items; most people do best with 7 items or less).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9
gt; >CREATE TRIGGER mytablen_trig BEFORE INSERT OR UPDATE OR DELETE ON
> >mytablen
> > EXECUTE PROCEDURE setlastchange();
> >
> >Is table caching good idea?
> >Is this best way to implement table caching ?
> >
> >Andrus.
>
> ---(end of broadcast)---
kept in the
> declared order.
Ugh, and here I'd been doing it the other way around. I assume
variable-length stuff should always go last, right?
This make sense?
Variable goes last, always
Larger alignment before smaller
NOT NULL before nullable
--
Jim C. Nasby, Sr. Engineering Consu
ile permissions.
FWIW, this is exactly what Oracle does. A DBA has to configure what
directories you can bulk copy to/from.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
---(end of broa
ur un-ordered query as a subquery in the FROM clause and
then order that it will work well. IE:
SELECT *
FROM (SELECT ...) a
ORDER BY f1, f2, f3
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
st day of the week
to be something other than do it through a global setting.
ISTM that would be much less error prone than having to make sure you
used it in all your function calls (not to mention a lot less typing...)
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive
eaf index
pages cached, since they take a fairly small amount of memory and are
frequently accessed. This makes index traversal *much* faster than your
initial case shows, even if you query on something different each time.
Testing with a completely empty cache just isn't that realistic.
--
Ji
On Tue, Aug 23, 2005 at 12:27:39AM +0200, Ben-Nes Yonatan wrote:
> Jim C. Nasby wrote:
> >Emptying the cache will not show real-life results. You are always going
> >to have some stuff cached, even if you get a query for something new. In
> >this case (since you'll ob
could end up back in the same position, which would mean the same
ctid.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
---(end of broadcast)---
TIP 9: In versio
ible to have a collision in this scenario unless you
roll the clock way back AND reset the sequence (assuming you're using an
integer sequence).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
--
not, perhaps work around it.
>
> I hope this is helpful. Let me know if there's some reason my plan won't
> work.
>
> Regards,
> Jeff Davis
>
>
>
>
> ---(end of broadcast)---
> TIP 9: In versions belo
rresponding views if a table's structure (add/delete
> fields, etc.) is changed.
There's not currently a TODO for this, no.
http://www.postgresql.org/docs/faqs.TODO.html I'm not sure how hard it
would be to do, since currently CREATE VIEW v AS SELECT * FROM t
actually expands
t;
> ALTER VIEW foo RECOMPILE
>
> Or I guess you could have the latter and then add the former as a view that
> automatically recompiles any time a object it depends on is altered.
I agree that CREATE DYNAMIC would be a good thing to have. It would
certainly save me time on some o
On Sat, Aug 27, 2005 at 12:50:44AM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > > I wonder whether it would be saleable to have an option to work around
> > > this
> > > "feature". I'm thinking one of two directions:
> > >
> >
use might be more efficient as
WHERE pontos_0 > pontos_7. Some databases would be able to use indexes
to answer that (not sure if PostgreSQL could), plus it removes an
operator. It also seems to be cleaner code to me. :)
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
P
people think about the Oracle method where bulk data operations
can only occur in a specified directory? Making that restriction might
address some of the security concerns. I don't think we should change
COPY in such a way that you *have* to use a specified directory, but if
it was an option
I set it to 10MB. That means (to me, anyway) that
> work_mem will never gobble more then 100MB. Seems OK since I have
> 1GB.
That's not totally true. A single query can use work_mem for multiple
steps, so if work_mem is 10MB a single query could end up using 20MB,
30MB, or even mor
, 'Software - Network', 2, '2004-10-12 10:50:04'),
> (14, 'Software - Midrange, AS/400', 2, '2004-10-12 10:50:04'),
> (15, 'Software - Server', 2, '2004-10-12 10:50:04'),
> (16, 'Hardware - Wyse Terminal', 2, '2004-10-12 10:50
gt; >> (13, 'Software - Network', 2, '2004-10-12 10:50:04'),
> >> (14, 'Software - Midrange, AS/400', 2, '2004-10-12 10:50:04'),
> >> (15, 'Software - Server', 2, '2004-10-12 10:50:04'),
> >> (16, 'Hardware - Wyse Terminal&#x
ase will be hosed.
I thought PostgreSQL already had such a safeguard? Or is it only against
starting two backends against the same PGDATA on the same machine?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcar
ocking these days. Especially
> with 8.0 on Windows. I was really impressed how far it has come since
> the 6.x days running on Cygwin.
3rd hit on google:
http://www.sqlmanager.net/products/postgresql/manager/documentation/hs20160.html
--
Jim C. Nasby, Sr. Engineering Consultant
On Tue, Sep 06, 2005 at 02:58:52PM -0500, Bruno Wolff III wrote:
> On Tue, Sep 06, 2005 at 13:47:42 -0500,
> "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> > On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote:
> > > On Mon, Sep 05, 2005 at 12:20:
lt or impossible to do with cron
become available, such as sub-minute scheduling (ie: every 30 seconds),
running something at server start-up/shut-down, running something based
on a notify, etc.
I encourage anyone who's interested in this to join the mailing list at
http://lists.pgfoundr
pretty easy to do, so why not help those who could make
use of it?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
-
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 5: don't forget
On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote:
> On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> > > Xlog will be the only believable data if your system crashed. So it is a
> > > dan
>>
> >>
> >Cron can log to syslog.
> >
> >Karsten
> >
> >
> And your cron scripts could log to your database log tables if that is
> what you were getting at...
True and true, but both of those require more work to setup. I'm not
even sure i
On Fri, Sep 09, 2005 at 09:43:56AM -0500, Scott Marlowe wrote:
> On Wed, 2005-09-07 at 16:15, Jim C. Nasby wrote:
> > On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote:
> > > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> > > > On Wed, Sep 07, 2005
ODO for this, since it's something that's
asked about fairly often.
* Provide a means for individual queries to be run at a lower priority
While nice allows this for CPU-bound queries, it generally doesn't
work for I/O bound queries.
--
Jim C. Nasby, Sr. Engineering Consultant
tid
HINT: Use an explicit ordering operator or modify the query.
ERROR: could not identify an ordering operator for type tid
HINT: Use an explicit ordering operator or modify the query.
decibel=#
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
1 - 100 of 641 matches
Mail list logo
