stgres will try to open a socket on 1.2.3.4. Bang!
Apart from that:
a) nslookup is deprecated since ages, use "host" or "dig" (well, no, use
"getent hosts" ;-)
b) I doubt that all DNS possible servers (M$ ones spring to mind...)
will provide answers to "localho
ng large return sets (and
in the worst case, take a lot of time to "collect" them).
You might consider deploying atop (atoptool.nl), which offers to sum up
all data based on user and/or process name, and will enable you to track
the usage stats to the past. Plus the latest version
tuation, pg_restore sounds more reasonable
I've luckily never been in your situation, but I'd guess pg_dump will
just happily dump what it sees. It's not like a seq scan will realize
"oh, I've seen that value before" and bail out. The _restore_ will bring
it t
ffect
you're looking for with InnoDB or Oracle, but not with PG.
Cheers,
--
Gunnar "Nick" Bluth
RHCE/SCLA
Mobil +49 172 8853339
Email: [email protected]
__
In 1984 mainstream users were choosing VMS
What is considered the best filesystem to use for postgres data stores ?
On Fri, Oct 22, 2010 at 11:17 AM, Kevin Grittner
wrote:
> I've not seen anything remotely like that. I wonder what's
> different
I did a test with the same postgres build (and autovacuum_naptime = 1
as well) on the same OS with only the system databases (postgres,
template0, template1), and
Oct 21, 2010 at 2:59 PM, Kevin Grittner
wrote:
> Nick wrote:
>
>> I have a production server running postgres 8.3.11. I did a dump
>> all and loaded up postgres 9.0.1 on another server. On the new
>> server, the postgres autovacuum launcher process eats up an insane
>
I have a production server running postgres 8.3.11. I did a dump all
and loaded up postgres 9.0.1 on another server. On the new server,
the postgres autovacuum launcher process eats up an insane amount of
ram (I have seen 17G virt with 6.5G res). On the older version, it's
at a reasonable 9MB re
tgreSQL
dbs and I either dump sql and then import or use PHP scripts when moving
between the two.
Nick
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
> -Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 10:13 AM
> To: Hajek, Nick
> Cc: [email protected]
> Subject: Re: [ADMIN] Server Crash
>
> On Tue, Apr 22, 2008 at 8:14 AM, Hajek, Nick
>
e any thoughts?
thanks,
Nick
at the only motivation to move forward is so I don't have
to feel ashamed to admit how far back we are. On the bright side, it's
an indication of how good postgresql is that a growing business has
had no issues with a quite old version.
Regards,
-Nick
On 8/8/07, Decibel! <[EMA
On 8/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> > One other question- when I'm vacuuming, I always get the warning:
>
> > WARNING: some databases have not been vacuumed in transactions
> > HINT:
On 8/8/07, Nick Fankhauser <[EMAIL PROTECTED]> wrote:
> the largest containing rows.
Oops- I meant to say "...the largest containing 56 million rows".
One other question- when I'm vacuuming, I always get the warning:
WARNING: some databases have not been vacuum
tions are
occurring? If so, how to I deal with template0?
Thanks.
-Nick
--
------
Nick Fankhauser
[EMAIL PROTECTED]
http://www.doxpop.com
765.965.7363
765.962.9788 (Fax)
Doxpop - Public Records at Your Fingertips.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: Wednesday, August 08, 2007 9:34 AM
> To: [EMAIL PROTECTED]
> Cc: [email protected]
> Subject: Re: [ADMIN] Transaction-Overflow
>
> [EMAIL PROTECTED] writes:
> > The hardware i
Dear Folks,
On 24/07/07 05:31 +1000, Nick Urbanik wrote:
Dear Jim,
On 15/05/07 20:28 -0500, Jim C. Nasby wrote:
On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote:
Dear Alvaro,
On 15/05/07 21:12 -0400, Alvaro Herrera wrote:
>Nick Urbanik wrote:
>>On 15/05/07 18:53 -040
Dear Jim,
On 15/05/07 20:28 -0500, Jim C. Nasby wrote:
On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote:
Dear Alvaro,
On 15/05/07 21:12 -0400, Alvaro Herrera wrote:
>Nick Urbanik wrote:
>>On 15/05/07 18:53 -0400, Alvaro Herrera wrote:
>You probably need to better confi
run vacuum full on such a large database (24G) and am
desperate to get the application back online.
--
Nick Urbanik RHCE http://nicku.org[EMAIL PROTECTED]
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
pgpBmysfrTMWM.pgp
Description: PGP signature
Dear Alvaro,
On 15/05/07 21:12 -0400, Alvaro Herrera wrote:
Nick Urbanik wrote:
On 15/05/07 18:53 -0400, Alvaro Herrera wrote:
>Instead of waiting a month for the time when you can take the
>application offline (thus accumulating a month's worth of dead tuples),
>run a non-fu
Dear Folks,
I would like to extend a big "Thank You" to all the great people who
answered my questions so quickly and helpfully. I'd love to buy you
all a beer!
On 15/05/07 19:59 -0500, Jim C. Nasby wrote:
On Wed, May 16, 2007 at 09:37:28AM +1000, Nick Urbanik wrote:
Will
the current table remain if the vacuuming
process is interrupted?
This is PostgreSQL 7.3.8.
--
Nick Urbanik RHCE http://nicku.org[EMAIL PROTECTED]
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
pgppQDnWCiRzO.pgp
Description: PGP signature
Thank you Geoff,
On 15/05/07 16:11 -0700, Geoff Tolley wrote:
Nick Urbanik wrote:
If you're waiting on vacuum to get around to the one table, you can run
VACUUM FULL instead.
Clearly that is what I should have done! It has reached the table now.
Personally I've found tha
, relpages 187502
3. This is PostgreSQL 7.3.8.
--
Nick Urbanik RHCE http://nicku.org[EMAIL PROTECTED]
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
pgpLUP2RGS30O.pgp
Description: PGP signature
ository for the rpms or src code. I
> have had a look on Postgresql homepage but the rpms are
> specific to Redhat and Fedora.
>
> Cheers
>
> --
> Chuck Amadi
I have 8.2.3 running on SuSE 10.2 without problem. I downloaded the
source .tar.gz file and built it, also without
Problem solved. I had config files in /etc/ and in /usr/ . :)
On 10/31/06, Nick Black <[EMAIL PROTECTED]> wrote:
Hello,
I am having difficuilties connected to the postgres server. I asked
on IRC, but everyone was stumped, so here we go.
My pg_hba.conf file:
# TYPE DATABASE
d postgres, nick and osm and unix users
called nick and postgres. I created users nick and osm using the
createuser script.
I can connect to postgres and nick without any problems, but if I try
to connect to osm, the following happens:
[EMAIL PROTECTED] $ psql -U osm -W -d template1
Password fo
iptables -A OUTPUT -p tcp \
--dport 1024:65535 \
--sport 5432 \
-m state --state ESTABLISHED,RELATED \
-j ACCEPT
but these should be the same both during boot and after the boot process has
finished
Nick
--
Nick Howden - Senior IT Analyst
QinetiQ Trusted Infor
a what the problem might be?
Postgres Version: 8.1.4
OS: Ubuntu Linux 6.0.6
Thanks
Nick
--
Nick Howden - Senior IT Analyst
QinetiQ Trusted Information Management
Woodward Building, Room B009
Malvern Technology Park, WR14 3PS
Telephone 01684 895566, Fax 896660
The Information contained in this
a what the problem might be?
Postgres Version: 8.1
OS: Ubuntu Linux 6.0.6
--
Nick Howden - Senior IT Analyst
QinetiQ Trusted Information Management
Woodward Building, Room B009
Malvern Technology Park, WR14 3PS
Telephone 01684 895566, Fax 896660
The Information contained in this E-Mail and any
unsubscribe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
e confirm that this is indeed affecting the database for all
sessions and if so, suggest a way to turn off the triggers just for the
session doing the data copy?
Thanks
-Nick
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765
area
(http://www.postgresql.org/docs/7.3/static/index.html) is working. I just
used it moments ago.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of 3rd.
> Sent: Monday, September 01, 2003 7:58 PM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] YO
cation and support.
Thanks (I mean it!)
-Nick
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
--
Oops- forgot to give the version on that last question:
I'm running version 7.3.2 on a Debian Linux platform.
-NF
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court recor
> Just out of curiosity, what happens if you make it bigger than 92k?
> Does a value 10x or 100x reality change the plan?
Neither one makes a change- perhaps something else is at work here- my
understanding of the finer points of query plans is shaky- Here is the query
and the plan I'm getting:
g_class & 'event_date_time' in pg_attribute, everything became clear.
So... I updated stadistinct to the actual value of 92,000 as you suggested
and as you predicted, it did not change the plan a bit. I guess I'll look
elsewhere for ways to optimize this query.
Thanks!
-Nick
e default stats, it is more like a factor of 6,
which seems significant to me, and if my conjecture is correct, it might be
an easy fix. (Easy for me to say, since I'm not a developer. )
-Nick
---(end of broadcast)---
TIP 8: explain analyze is your friend
Oops- forgot to give the version on that last question:
I'm running version 7.3.2 on a Debian Linux platform.
-NF
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court recor
00 if I re-run analyze a few
times.
I guess my question is two-part:
(1)Is there any tweak to make this estimate work better?
(2)Since I'm getting numbers that are consistent but way off, is there a bug
here?
(2-1/2) Or alternately, am I totall
solution but could someone
explain why I can start Postgres from the command prompt but not as a
service? Also what are the effects of reducing some of the parameters
mentioned in the error message?
Many thanks
Nick
---(end of broadcast)---
TIP 6: Have yo
Use currval()
See:
http://www.postgresql.org/docs/7.3/static/functions-sequence.html
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Pierre Couderc
> Sent: Friday, August 29, 2003 11:27 AM
> To: [EMAIL PROTECTED]
> Subje
your case, you'd substitute 254 for 104, your table name for "actor" and
your field name for "actor_full_name";
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jodi Kanter
Sent: Tuesday, August 19, 2003 1:34 PM
To: Postgres Admin
x27;t available & we learned that
postmaster doesn't complain if it is missing- I suppose this might be the
case with pg_hba as well, but I've never tested it.)
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Gregory S.
&g
mailto:[EMAIL PROTECTED] Behalf Of David Olbersen
> Sent: Tuesday, July 22, 2003 4:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] pg_restore problem!!!
>
>
> Nick,
>
> > pg_dump dbname | gzip > dbdumpfile.gz
> >
> > gunzip -c dbdumpfile | psql dbname
base, it also makes sense to compress on the fly to
avoid filesystem size limits, so I usually use this pair of commands for
backup/restore:
pg_dump dbname | gzip > dbdumpfile.gz
gunzip -c dbdumpfile | psql dbname
-Nick
---(end of broadcast)---
T
Mago-
pg_restore is used to restore a dump file created in one of the non-text
formats such as tar format.
To restore from a plain-text dump file, just pipe it into psql like so:
cat [filename] | psql [dbname]
-Nick
-
Nick
398)
[EMAIL PROTECTED]:~$
[EMAIL PROTECTED]:~$
[EMAIL PROTECTED]:~$ ls -al dump.tar
-rw-r--r--1 nickfnickf1388367872 Jul 21 14:49 dump.tar
[EMAIL PROTECTED]:~$
Note also that the file size is well under 2GB.
Thanks for looking it over.
-Nick
---(end of broadcast)
elect access on the table?
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Olivier Reuland
> Sent: Monday, July 21, 2003 7:56 AM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] common_fields: permission denied
>
>
> Hi there,
.
Thanks for the idea. (That was my first thought as well.)
-Nick
> how big does your tar file get when you get the error?
> I would guess that its 2GB at this time, which would indicate
> that you just
> hit a File System Limit.
> To prevent this, I guess you should use the &qu
ge blobs (mine has no
blobs), and the suggestion was to upgrade to 7.3. I couldn't find a
resolution in that thread, so I'm not sure if it ever got worked out.
Any thoughts??
Thanks!
-Nick
-
Nick Fankhauser
ggestion was to upgrade to 7.3. I couldn't find a
resolution in that thread, so I'm not sure if it ever got worked out.
Any thoughts??
Thanks!
-Nick
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.
> Does it stop at a filesize limit imposed by the OS or filesystem, such
> as 2.0GB as commonly found on linux, or NFS?
No, in this case, it is stopping at about 1.3 GB uncompressed. I usually
pipe the pg_dump output into gzip but removed the gzip to simplify the
situation while testing. Under
ggestion was to upgrade to 7.3. I couldn't find a
resolution in that thread, so I'm not sure if it ever got worked out.
Any thoughts??
Thanks!
-Nick
-
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.
uld at least be a warning if the file is not found.
Ironically, the problem in this case turned out to be the permissions, so
apparently the existing warning didn't clue one person into what was
happening until I made the suggestion about permissions more explicitly.
-Nick
--
distribution, so there may be something odd
about the directory structure that I'm missing.
Is there a SuSe user on the list that can help?
Thanks
-Nick
-----
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765
distribution, so there may be something odd
about the directory structure that I'm missing.
Is there a SuSe user on the list that can help?
Thanks
-Nick
-----
Nick Fankhauser
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765
order. I
quickly concluded that as long as space allows, I preferred the simpler
approach of two backups since I don't have to remember to edit my shell
script every time a make a change to the database. Like you, I prefer my
tools for mid-disaster to be simple.
-Nick
> -Original Me
It means you need to give that error message to your system administrator,
who will understand what it means.
If you are the system administrator, use "df" to learn which filesystem is
full & then spend some time learning about filesystem management so you can
fix it.
-Nick
&
advise
Nick Kelly
installing on windows.doc
Description: MS-Word document
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Michael-
This document should get you started:
http://www.postgresql.org/idocs/index.php?tutorial.html
look at section 1.3 in particular.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Cupp
> Sent: Monday, January 27
e because it is
expecting more than 2 columns, but fails in the second when it attempts to
process the third and subsequent columns. Looking at the java code for
processing the result would tell us for sure.
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Beha
Your SQL statement may look fine, but you're either setting or getting
something that it doesn't have.
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of helen liu
Sent: Monday, January 13, 2003 11:44 AM
To: [EMAIL PROTECTED]
Subject: [
rows this
is very slow.
So, can I force the query optimizer to delay doing the ~* until after the
selective joins?
--
Nick Howden - Senior IT Analyst
QinetiQ Trusted Information Management
Woodward Building, Room B009
Malvern Technology Park, WR14 3PS
Telephone 01684 895566, Fax 896660
The I
u had entered
"Sting" at first, after several thousand records had been created that
referred to this in the main table, you would be able to correct your
spelling for all of them by changing a single field in the lookup table...
-Nick
-Original Message-
From: [EMAIL PROTECTED
Paul-
> Finally, I ran 'ps -ef' just after the postmaster successfully started (or
> so it says), but there's no sign of any postgresql related processes:
This is clearly your problem. See if you can locate the log file & find out
why the processes are dying right away. Usually the location of th
give you that ability.)
Duplication of data is kept to a minimum.
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter
Sent: Friday, December 06, 2002 10:46 AM
To: Postgres Admin List
Subject: [ADMIN] proper db standard
I am creat
> You could check this by running pg_restore with query logging
> turned on, to see what commands it's actually issuing -- or just do
> "pg_restore -s" into a text file and eyeball the generated script.
I did this, and there is a view created before the table it refers to.
> There are a lot of
e
conveniently should the need arise. I've used the text dump & frequently
done a full restore by piping it into to psql without problems before, so I
can confirm that for our database, the objects get created in the correct
order when
this is a standard sort of
operation that other people would be using often.
-Nick
> It sounds as though you are trying to restore an item which is already
> in the database. Perhaps this snippet from the pg_restore man page may
> be relevent:
>
> If your installation h
a plain text dump file, so I'm still mystified.
Any thoughts?
Thanks.
-Nick
------
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulti
you did your own install, let me know & I'll send you a copy of the
startup script that came with the Debian package off-list.
Alternately, I recommend just using the Debian package if you don't mind
being one step back from the cutting edge.
-Nick
-
Oops...
> Nope, this is definitely a message from the postgresql backend.
What I *meant* to type was:
this is definitely a message from the postgresql backend referring to too
many client connections.
---(end of broadcast)---
TIP 2: you can get o
>> If you aren't using pooled
>> connections, maybe you just have more users on the web.
>
> But is there really that number of backends/connections present?
Assuming there is no connection pooling going on, then yes, it is reasonable
to assume that more users means more connections. (I don't kn
w. If you aren't using pooled
connections, maybe you just have more users on the web.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of A.M.
> Sent: Friday, November 08, 2002 12:31 PM
> To: [EMAIL PROTECTED]
&
to try the pgsql-php mailing list.
-Nick
> -Original Message-
> From: fred [mailto:fred@;skyturn.net]
> Sent: Wednesday, November 06, 2002 8:36 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] USERS
>
>
> Thank you very much.
>
>
Fred:
Try following this link to the interactive Doc:
http://www.postgresql.org/idocs/
This link will tell you how to allow tcp/ip access using the pg_hba.conf
file:
http://www.postgresql.org/idocs/index.php?client-authentication.html
This link will tell you how to make sure the server is acc
Andrew Perrin wrote:
- Do a formal backup more often
For what it's worth, the FreeBSD "port"
(http://cvsweb.freebsd.org/ports/databases/postgresql7/) for PostgreSQL
contains a most excellent daily maintenance script (as written it's a
FreeBSD "periodic" script, but it's more or less suitab
I just got done upgrading 2 databases from 7.1.x to 7.2.3. In both cases
the procedure outlined in pg_upgrade.1 failed. In one case, the failure
was catastrophic. In neither case was any data lost (because I backed up
with pg_dumpall first), but in both cases it appears the failure was
similar:
Hi. I have been a happy user of PostgreSQL for some time now. I am
begining a project that, much to my very slight annoyance, will involve
either CLOBs or BLOBs. My understanding is that neither is backed-up by
pg_dumpall (my backup strategy is that I do a pg_dumpall and mark the
actuall databa
the Athlon processors if you're
trying to reduce cost. From what I've read elsewhere, it sounds like you may
get comparable performance with a dual Athlon vs a Quad Xeon. Also remember
that in a server-class Sun box, you've got a nice I/O channel by default,
but in an Int
:
syslog = 0
silent_mode = off
debug_print_query = on
debug_pretty_print = on
I'm not sure if the pretty print option does anything for the SQL, but it
didn't hurt.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Phil
if this is possible & if so, what runtime settings are
needed?
Thanks
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services ht
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of ashwini sridhar
> Sent: Tuesday, July 09, 2002 8:51 PM
> To
oader or it's newer
equivalent on the dump file.
Of course we're all just aghast that you'd want to do such a thing...
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Camargo
> Sent: Friday, July 05, 2002 4:0
http://techdocs.postgresql.org/ (Look about halfway down the page)
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Camargo
> Sent: Wednesday, July 03, 2002 1:57 AM
> To: [EMAIL PROTECTED]
> Subject: [
Mark-
If you're on version 7.1 or higher, the proffered way to turn on tcp/ip is
to add "tcpip_socket=true" to postgresql.conf in the data directory. (Then
restart.) Details are here:
http://www.postgresql.org/idocs/index.php?runtime-config.html
Regards,
-Nick
> ---
o, take a look at your pg_hba.conf file. Info
on how to set it up can be found here:
http://www.postgresql.org/idocs/index.php?client-authentication.html
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax
file locations may vary by OS flavor, but in Debian, you can find a log
in /var/log/postresql.log. You may have to turn on logging in
postgresql.conf.
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax
You can set it either within the session, or set a default. For details,
check this page in the docs:
http://www.postgresql.org/idocs/index.php?sql-set.html
(Look for DATESTYLE)
Regards,
-Nick
--
Nick Fankhauser [EMAIL
Stats for function indexes would be nice, so add our vote for it to wherever
such things are tallied to come up with priorities.
Regards,
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
> Sent: Wednesday, June 26, 2002
usand rows really are returned indicates that the index would
still be a good choice. Is there a way to make the planner favor index scans
a bit more? (Other than the drastic set enable_seqscan to off.)
Thanks
-Nick
--
Ni
onf to you off-list, and you can use it as
a starting point to edit again, (using a unix editor this time ). Or
alternately, you can probably use a dos->unix filter on the old file.
Regards,
-Nick
--
Nick Fankhauser [EM
Well, since it is already in text format, just load it normally:
psql -f 20020422_project_summaries.gz
psql doesn't care what the name is so long as the internal format is OK.
If you want to, you can rename it. (I probably would to avoid confusion
among the humans.)
peans use
# day-month. Specify European or nonEuropean. Separate the two parameters
# by a comma with no spaces
PGDATESTYLE=SQL,nonEuropean
-Nick
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 8:39 AM
> To: [EMAIL PROTECTED]
.org/idocs/index.php?sql-expressions.html
Regards,
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
-Or
x.php?functions.html
You may also want to learn how to create your own functions in case there is
no equivalent:
http://www.postgresql.org/idocs/index.php?sql-createfunction.html
-Nick
--
Nick Fankhauser [EMAIL PROTECTED]
issues. (Like my silly questions!)
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
---
o move them to
postgresql, or simply how to make the run better in access?
Maybe if you restated the question you'd get some better responses.
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.
Try:
SELECT RazaoSocial || ' - ' || coalesce(Bairro || ' ','') || CGCCli As
Coluna FROM Clientes WHERE RazaoSocial Like '%A%';
>SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCC
1 - 100 of 179 matches
Mail list logo
