On Sun, 12 May 2002, Dan Langille wrote:
>
> On 12 May 2002 at 12:49, Brian McCane wrote:
>
> > I am on FreeBSD 5.0.
>
> There is a reason why you must be on 5.0? That is not recommended for
> "sane" people.
>
> 5.0 is -current and not the best place to
On Wed, 6 Jun 2001, Tom Lane wrote:
> "Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> > Does PostgreSQL support (or some day will support) "partitioned tables"?
>
> It's not on anyone's radar screen AFAIK.
>
> > Alternately, does anyone have an idea about how to address this need in a
> > diff
cnt=0
> fi
>
> psql dbname -c "UPDATE ... $line ..."
> let cnt=$cnt+1
>
> done < filename
>
> -
>
> I will leave it up to the reader to modify this to his/her *specific* need...
>
> --brett
>
>
On Thu, 18 Oct 2001, Tom Lane wrote:
> Brian McCane <[EMAIL PROTECTED]> writes:
> > An interesting point was that the duplicated key was actually in the
> > table, but the existing unique index was happy as a clam.
>
> Hmm. What datatype is the key, and what PG versi
following and feed it using standard input. Please NOTE, I didn't test
this, and even if I did, you shouldn't trust me :).
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid th
s me a headache
(and makes me 5-6 hours early for all of my appointments :).
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open wh
ctly. So, at least at first, I recommend that you look
at the SQL that is generated, and make sure you understand what it is
trying to do BEFORE you use it.
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock
; Thank you very much.
> >
> > Have a nice day ;-)
> > TooManySecrets
> >
> > --
> > Manuel Trujillo [EMAIL PROTECTED]
> > Technical Engineer http://www.motograndprix.com
> > Dorna Sports S.L. +34 93 4702864
> >
> > --
r the copy is made the old index is DROP'd, and the new one is
ALTER'd to the old name. Unfortunately, this means that you must have
enough room for the new index plus the old at the same time, but I am
sure that most people have lots of spare room. I seem to remember th
On Sun, 14 Oct 2001, Marc Spitzer wrote:
> In article <[EMAIL PROTECTED]>, Brian McCane wrote:
> >
> > Being the perpetually lazy person that I am, I have written a PERL script
> > that takes care of indexes on a live system. You tell the script the
> > databas
rigger with oid's to a
file, found the triggers using grep, and then deleted them by oid.
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.max
On Wed, 30 Jan 2002, Arguile wrote:
> Brian McCane wrote:
> > How can I list the triggers on a specific table?
>
> Just as I was typing this I noticed Tom already replied. Just incase you
> want to know all triggers referencing the table in addition to those on it
> (eg. fo
o my
client :). Is there any way to get the equivalent index from PostgreSQL?
This is a major show stopper for me at this point. I have looked through
Chapter 7 of the 'idocs', but I didn't find anything that would help.
- brian
Wm. Brian McCane| Life is full of do
On Thu, 14 Feb 2002, Tom Lane wrote:
> Brian McCane <[EMAIL PROTECTED]> writes:
> > CREATE INDEX foo_index ON foo (bazid, score desc) ;
>
> > Which would be exactly what I want, and would complete in a split second.
> > Instead, this thing runs FOREVER (okay
should be possible to have the optimizer leave col1 in a "high
impedence" state, and then allow col2 to make a decision. I have not
looked at the code, but if we have a known value for col1 as a constant,
I would think we could let subsequent information make the decision and
then just bubble
d? I set 'nextupdate' to tomorrow specifically
to prevent the 5 minute update from doing anything until the historical
data is available.
Any ideas?
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you
PostgreSQL without Multibyte support? Or has the indexing, etc. been
optimized so much for multibyte that it is actually faster than single
byte stuff?
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally s
.
>
>
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
Wm. Brian McCane
are doing access via ODBC. I'd be happy to provide any more
> information if it could help in solving the problem - and I'd be very
> happy about helpful advice.
>
> Thanks in advance,
>
>Markus
>
> ---(end of broadcast)---
e_epoch()::integer', but that failed as well.
Is it possible to make the default value of an integer field use a
function similar to how we use 'now()' for date and timestamp fields?
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search
ed in a transaction block.
-brian
On Fri, 12 Apr 2002, Brian McCane wrote:
>
>
>
> I have a field called 'updated' of type 'integer' in a table. I have
> created a function called 'since_epoch' which is declared with iscacheable
> and returns the
Been there, done that :). It put the current epoch value in as the
default value for updated.
- brian
On Fri, 12 Apr 2002, Tom Lane wrote:
>
> Brian McCane <[EMAIL PROTECTED]> writes:
> > alter table foo alter column updated set default 'since_epoch()' ;
> &
on a hundred times, I
get a hundred different answers. Once I do a 'BEGIN', the result never
changes again until I 'COMMIT', which is what I would expect according to
the docs I have found.
- brian
On Fri, 12 Apr 2002, Tom Lane wrote:
>
> Brian McCane <[EMAIL PRO
his.
>
>
>
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
Wm. Brian McCane| Life is full of doors that won't o
27; is '(did, sid)'. So,
the planner should know that for any 'did', there will be no duplicate
'sid', and each 'sid' is tied to a specific 'id' in 'v'.
Alternatively, there might be a better way to write this query. Any
ideas? I can't thi
ant
>
>
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.ne
termine
which index I actually use most (foo_ad), and then clustering the data
that way, or is there some other agent at work here.
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid
exes provided by contrib/tsearch can also
> lead to significant improvement in search performance.
>
> regds
> mallah.
>
> On Saturday 11 May 2002 05:48 am, Brian McCane wrote:
> > Okay, I guess I misunderstood something about "VACUUM FULL". My
> > understan
On Sat, 11 May 2002, Tom Lane wrote:
>
> Brian McCane <[EMAIL PROTECTED]> writes:
> > It appeared while the VACUUM FULL was occurring, that the index files were
> > sort of rewritten in place.
>
> No, it just has to make new index entries for the rows it moves. It
, restore the data, and re-enable the triggers?
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them t
consider
allowing someone into the machine, but it doesn't make me excited to
contemplate it.
- brian
On Sun, 12 May 2002, Tom Lane wrote:
>
> Brian McCane <[EMAIL PROTECTED]> writes:
> > Okay, now I am a little scared. Before I started rebuilding indexes, I
> >
On Sun, 12 May 2002, Dan Langille wrote:
>
> On 12 May 2002 at 12:49, Brian McCane wrote:
>
> > I am on FreeBSD 5.0.
>
> There is a reason why you must be on 5.0? That is not recommended for
> "sane" people.
>
> 5.0 is -current and not the best place to
e to debug this
issue in the vacuum code, but I would need some assistance figuring out
what I need to do.
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freen
ence
> with a one day period.
>
> Are there any better ways of converting a timestamp to an integer?
>
>
> Thanks
>
> Gareth
>
>
>
> ---(end of broadcast)---
> TIP 5: Have you checked our exten
a single disk.
> >
> > Thanks
> > Charlie
> >
> > ---(end of broadcast)---
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
> -
y suggestions on a quick way to do this?
>
> --
> Cliff Wells, Software Engineer
> Logiplex Corporation (www.logiplex.net)
> (503) 978-6726 x308 (800) 735-0555 x308
>
> ---(end of broadcast)-------
> TIP 6: Have you searched our list arc
d then
insert from the temporary table, but this is gonna take a long time.
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open w
m is not as good as deflate
- brian
Wm. Brian McCane| Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
Auction http://www.
Yes!!
I have done this very successfully. I have mounts:
/usr/local/pgsql/data 8Gig slice on Primary IDE-Slave
/usr/local/pgsql/data28Gig slice on Secondary IDE-Master
/usr/local/pgsql/data34Gig slice on Primary IDE-Master
Then I move files from data/base/ to data2/base/ and creat
39 matches
Mail list logo
