I wonder why this is not a VACUUM option.
On Fri, 16 Dec 2016 at 15:30 Kenneth Marshall wrote:
> On Fri, Dec 16, 2016 at 09:15:51AM -0500, Bill Moran wrote:
> >
> > Does anyone have experience using pg_repack on Postgres versions > 9.4?
> > Specifically 9.5, but probably 9.6 at some point.
> >
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devrim GUNDUZ wrote:
> Hi,
>
> On Wed, 2006-04-12 at 13:07 +0200, Gaetano Mendola wrote:
>> I was able to create it with:
>>
>> --nodeps --define 'buildrhel3 1' --define 'build9 1'
>
> I'll
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devrim GUNDUZ wrote:
> Hi Gaetano,
>
> On Tue, 2006-04-11 at 18:31 +0200, Gaetano Mendola wrote:
>> I'm trying to build the rpms for RH9,
>> I downloaded the srpm for RH9 but I'm stuck on these errors:
>>
>
Joshua D. Drake wrote:
> Gaetano Mendola wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hi all,
>> I'm trying to build the rpms for RH9,
>> I downloaded the srpm for RH9 but I'm stuck on these errors:
>
> RH9 is not a su
than 7.4 in certain scenarios?
Consider:
select f1(id), f2(id), ..., fn(id) from my_view;
where fi is eligible for be marked as "STABLE" but is not.
In 8.0 in that select are involved n+1 snapshots instead of one as it
in 7.4. Could this be a performance issue ?
Rega
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
how I already wrote, the RSS feed report as date:
1 jan 1970 for all entries.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
es
not exist in the archives. I think that NG is the best way to follow
the discussion and shall be at least a complete container for them and a
complete archive mirror too.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsub
ore then 2 minutes. My server is now hosted in my house and I do not
need it anymore, I changed it with the no-ip script :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Guy Fraser wrote:
Trivia: In approximately 620 million years a day will be twice as long
as it is today.
Do you think then that Postgres628M.0 will fix it ? :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your
quot;BEGIN")
except:
raise OperationalError, "can't rollback."
why do not distribute with next RPM the psycopg instead ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
e on non INNODB tables.
2) Create or delete and index or alter a table will recreate the entire
table.
3) Our rollback is a O(1) operation not O(N) where N is the operations
performed during the transaction
Regards
Gaetano Mendola
---(end of broadcast)---
here:
http://mendola.no-ip.com/rpm746.htm
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
es ) * 0.5 ;
double log_runs = ceil(LOG6(nruns));
double npageaccesses;
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
| On Fri, 2004-10-22 at 17:11, Gaetano Mendola wrote:
|
|>Scott Marlowe wrote:
|>
|>>On Wed, 2004-10-20 at 08:06, Dan Pelleg wrote:
|>>
|>>
|>>>I'm trying to access a table with about 120M
SELECT * FROM table WHERE col='1' AND row='10';
also, have you vacuumed / analyzed the table? I'm assuming yes.
I assume not, seen that cost...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Tom Lane wrote:
Since we don't yet have bitmap combining of indexes...
^^^
Are you trying to tell us something ? :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Christopher Browne wrote:
> Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall:
>
>>Chris Browne wrote:
>> > The Slony-I team is proud to present the 1.0.4 release of the most
>> > advanced replication solution for the most advanced Op
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dennis Gearon wrote:
| Gaetano Mendola wrote:
|
|> Dennis Gearon wrote:
|>
|>> I am designing something that may be the size of yahoo, google, ebay,
|>> etc.
|>>
|>> Just ONE many to many table could possibly have the
y1/download/slony1-1.0.4.tar.gz
May I use it on a machine with a postgres 7.4.5 installed with RPM ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
think you'll have nightmares with it...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
why do not include the psycopg instead of the actual
python driver ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hicham G. Elmongui wrote:
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
No, at my knowledge you'll obtain the first tuple only when
the function exit.
Regards
Gaetano Mendola
---(e
Barry S wrote:
Thats fine, but you do understand that nice (linux) will have *no*
effect on I/O?
I do.
For any non-trivial table (that can't be held entirely in memory),
re-nice will almost certainly have no effect.
That's my feeling too, but at least is a try.
Regards
Gaeta
dn't lost any data.
Regards
Gaetano Mendola
PS: I had the same error for the first time in my postgres usage life
only after ( some weeks after ) having upgrade from a 7.4.2 -> 7.4.5
---(end of broadcast)---
TIP 5: Have you checked our extensi
Gaetano Mendola wrote:
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only
run SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access stat
ith 0 your file ( blocks of 8K ) till reach that offset reclaimed.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
L query "SELECT."
Is there a way to get rid of these messages
modify your log_error_verbosity to "terse"
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ith 0 your file ( blocks of 8K ) till reach that offset reclaimed.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Ann wrote:
> I found the reason of this question and fixed the bug :))
>
Why then don't you share it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Joseph Shraibman wrote:
That is what I wanted to know, how to get the evidence for next time.
select * from pg_locks
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
Tom Lane wrote:
> Gaetano Mendola <[EMAIL PROTECTED]> writes:
>
>>I feel that renice a backend will not kill your system.
>
>
> It won't kill the system, but it probably won't accomplish what you
> hoped for, either.
>
That's true but right now reni
database" in the same sentence is like put
"windows" and "security" in the same sentence too...
I feel that renice a backend will not kill your system.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Simon Windsor wrote:
> Hi
>
> Can you provide a link to the interview?
Ops! I forget it :-(
Here it is: http://www.alwayson-network.com/comments.php?id=6186_0_4_0_C
Regards
Gaetano Mendolaa
---(end of broadcast)---
TIP 8: explain analyze is your frie
ot more robust
than his counterpart *nix 8.0 this because lot of code already mature in *nix
environment is new in the win32 one.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
quot;, indeed
as the
last JDBC interface version this interface delay the transaction open at the first
statement. I think that the new postgres rpm shall insert this interface instead the
PyGres one.
Regards
Gaetano Mendola
---(end of broadcast)--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew T. O'Connor wrote:
| Gaetano Mendola wrote:
|
|> Matthew T. O'Connor wrote:
|>
|>> Since you are running autovacuum I doubt the doing vacuumdb -a -z is 3
|>> times a day buying you much. It's not
Matthew T. O'Connor wrote:
On Sun, 2004-10-03 at 21:01, Gaetano Mendola wrote:
Tom Lane wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
Christopher Browne wrote:
pg_autovacuum -d 3 -v 300 -V 0.5 -S 0.8 -a 200 -A 0.8
I'm not very familiar at all with appropriate settings for
Tom Lane wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
Christopher Browne wrote:
Assuming that the tables in question aren't so large that they cause
mass eviction of buffers, it should suffice to do a plain VACUUM (and
NOT a "VACUUM FULL") on the tables in question quite
map: 141 relations, 26787 pages stored; 26032 total pages needed
DETAIL: Allocated FSM size: 1000 relations + 200 pages = 11780 kB shared memory.
Regards
Gaetano Mendola
PS: I do not have any "idle in transaction" connections around.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Astha Raj wrote:
Hi All,
I want to connect to PostgreSQL 7.4 from my Windows machine. What ODBC
version is needed? Is there any other important settings required? I am very
new to this database.
Search on google: "odbc postgresql" and I'm feeling lucky.
Regards
=
But I think that's not bad.
Ouch. This is the same error already seen on OSX !! Tom Lane modified the
test in order to get rid this from that OS. It's not bad, however now
are two platforms with that glitch.
Regards
Gaetano Mendola
---(end of bro
-09-28 17:10:47 CEST] analyze_threshold: 4464024; vacuum_threshold:
2790190
for the point 2) I suggest you to "cron" analyze during the day.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ransactions from acquiring a lock on the same row,
so those transactions will block until the transaction holding the
lock completes.
There are some proposal to have another kind of lock in order to avoid the
above. I hope soon.
Regards
Gaetano Mendola
---(end o
50
(3 rows)
test=# select length(a) from test where a =
'01234567890123456789012345678901234567890123';
length
44
(1 row)
Just an idea, could you reindex your table ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
END;
' LANGUAGE 'plpgsql';
Did you execute it ?
rg_int is not declared, may be is a typo for arg_int; however
you can not modify the argument function.
Is it an homework ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
MaRCeLO PeReiRA wrote:
Hi guys,
How can I know about the number of active
connections?? (not the maximum allowed, but the number
of open connections).
If you have enough permission:
select count(*) from pg_stat_activity;
Regards
Gaetano Mendola
---(end of broadcast
Greg Stark wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
Well, when SHA-0 was ready NSA suggested to apply some changes in order to
correct some flaw discovered and SHA-1 comes out, interesting NSA never wrote
which flaw was corrected!
May be SHA-1 is trasparent water to NSA eyes :-)
rule you can do it easily ( never tried ).
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
uot;
"select * from pg_locks"
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeremiah Elliott wrote:
| Gaetano Mendola wrote:
|
|> Barry S wrote:
|>
|>> In article <[EMAIL PROTECTED]>, "Christine Desmuke" wrote:
|>>
|>>> Hello:
|>>>
|>>> At the risk of starting a fl
ion? I'd be hesitant to
throw around data over the Internet without using SSL for all the
various reasons: DNS hijacking, TCP replay, etc.
If not you can tunnel it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ign
Barry S wrote:
In article <[EMAIL PROTECTED]>, "Christine Desmuke" wrote:
Hello:
At the risk of starting a flame-war, I'd like some more details on the
use of Gentoo Linux for a production PostgreSQL server. There have been
a couple of comments lately that it is not such a great idea; does
anyone h
/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
I'm not finding the equivalent for 7.4 about the first link.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index sc
che_size = 4000
I don't know what changes from 7.2 -> 7.4 but effective_cache_size
is too little IMO, or at least incongruous with sort_mem.
Try to rise that parameter to something more realistic.
Regards
Gaetano Mendola
---(end of broadcast)-
EXECUTE it. Doing it that
way seems a bit ugly, though, and it'd make maintenance a bigger problem.
Right now unfortunately this is the only one solution.
See the post on performance (8/28/2004) with the title:
ill-planned queries inside a stored procedure"
Regards
Gaetano Me
_customer ON UPDATE to cust_items
WHERE NEW.type='featurex' AND
NEW.customer_id IN
(SELECT customer.id FROM customer
WHERE featurex=TRUE
)
DO ... ?
Any pointers, hints, or info on this kind of statement?
This is a trigger job not a rule one.
Re
nd, see the post where
I did some tests.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Secrétariat wrote:
I don't have a telnet server on the Win XP Pro PC acting as PG server for
Beta1 !
So ? If you do: telnet 5432
the command only open a TCP connection to the port 5432,
this will test if you are able to reach your server.
Regards
Gaetano Mendola
---(e
while ( type(result) is type([]) ):
result = result[ 0 ]
print result
this is working correctly on my 8.0beta1 installation
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ASK METHOD
local all all md5
# IPv4-style local connections
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
# IPv6-style local connections:
#host all all ::1/128 md5
If you want allow all the network 192.168.0.0 then
your netmask have to be: 255.255.0.0
Reg
resql : "super distribution" ?
Is this the way that the core is following? Is the time mature enough ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
e performed
with the server up and running.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
pip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?
Show us your pg_hba.conf, what is the exact error ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don'
e that permit more servers to share an unique shared memory
segment and then with the help of SAN you can have two postmaster that
are running on two different server that are belonging to a SAN and the
common shared memory segment.
Right now your only solution is buy a multiprocessor machine.
Regar
t up to date or you
have to increase your default_statistics_target.
337 rows vs 3618 rows
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
in vacuum
takes 200 seconds and the vacuum full immediately after
takes 620 seconds.
In both case the cpu usage was near zero.
I'm using a 2.2GHZ 1GB di RAM and I'm using 64MB to workmem.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Oleg Bartunov wrote:
Marcel,
On Thu, 19 Aug 2004, Marcel Boscher wrote:
For now i am almost statisfied with my tsearch2 installation war over night
somehow it seems to work, finally...
What does have tsearch2 that htdig doesn't have ( for index document I mean ) ?
Regards
Gaetano Me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>I did last week an Ariadne+Postgresql valutation for the company where I work
|>and I learned that
|>with 250 MB you can open up to 80 concurrent query
|>with 500 MB
o "raise notice" inside the trigger function and observe
the results
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
ons more
if you break these rules that machine trash...
Peter for 1 connections need then 61 GB that is quite amazing :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Type.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBGVHq7UpzwH2SGd4RAriNAKDRKJCpgGen8VVsxg//rmjqU+O6vgCg4u/9
9zcAUYNCfaeU2i9WVTXdh3k=
=5YeH
-END PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rajesh Kumar Mallah wrote:
|
| The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/
| and possible all mirrors leads to nowhere. I guess many people
| would click there.
It works for me.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
: No such file or directory.
This might be caused by an FTP URL with an absolute path (which does not comply with
RFC 1738).
If this is the cause, then the file can be found at
ftp://ftp3.us.postgresql.org/%2f/pub/postgresql/beta.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuP
87838);
and repeat it again but executing before:
set enable_seqscan = off;
Depending on the results that you get may be you need to lower the index
scan cost tuning the cpu related GUC variables.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comm
ld be more sensitive than
Oracle?
Anyone ever done this before in a production environment?
thanks!
Do you trust your data to a udp connection ?
We had problem in copying big files ( 1.9GB ) in a mounted NFS partition
and now we prefer to not use it anymore for our data.
Regards
Gaetano Me
not thread safe? how do i make it so it is?
|
| thanx, amir
|
| On Fri, 06 Aug 2004 10:54:07 +0200, Gaetano Mendola <[EMAIL PROTECTED]> wrote:
|
| Amir Zicherman wrote:
|
| | I have the following 2 functions and I'm getting deadlocks when I call
|
|
| | them from multiple threads. The fir
ar, b varchar, c varchar );
CREATE TABLE
regression=# create unique index test_idx on test ( upper(a), upper(b), c);
CREATE INDEX
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozde
uently then other and you have enough
RAM your OS will mantain that table on RAM, don't you think ?
BTW if you trust on your UPS I'm sure you are able to create a RAM
disk and place that table in RAM.
Regards
Gaetano Mendola
---(end of broadcast)---
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
this help you.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
tion backend; do you
have back end sitting there days and days in that state ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lamar Owen wrote:
| On Monday 02 February 2004 10:54 pm, Tom Lane wrote:
|
|>Gaetano Mendola <[EMAIL PROTECTED]> writes:
|>
|>>Is someone taking care about the fact that the pgdb.py shipped with
|>>7.4.1 is the wrong version?
|
tion:
http://archives.postgresql.org/pgsql-bugs/2002-12/msg00082.php
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
, I really didn't dig on it to see the usage of that
value.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
hipped with
postgresql-python-7.4.1-1PGDG.i386.rpm
this problem was solved already on 7.3
look this:
http://archives.postgresql.org/pgsql-bugs/2002-12/msg00082.php
something did wrong during the SRPM file building for the 7.4.1
Is a good idea look how this happen.
Regards
Gaetano Mendol
oid
inside the file pgdb.py with this one:
"SELECT typname, 4, typlen "
"FROM pg_type WHERE oid = %s" % oid
just to not break all file.
I'm not able to look at CVS to see where the modification was lost.
Regards
Gaetano Mendola
---(end of broadc
solution solve different problems:
1) DEFAULT now()
you'll have the timestamp of transaction
2) DEFAULT timeofday()
you'll have the timestamp of insertion
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have yo
;t mentioning the fact that for Oracle a zero length string is NULL!
Isn't that funny ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
[EMAIL PROTECTED] wrote:
Please, read this carefully: http://sql-info.de/mysql/
I can not believe it!
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
sn't complain neither.
And the funny here is that FK are not yet supported !
No regards.
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
this also related to the fact that gdb on libraries of RH9.0 don't
complain about the debugging info ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joinin
tracking
tool that have is not too much evolved, try it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Linux
# elvtune /dev/sda7
/dev/sda7 elevator ID 5
read_latency: 64
write_latency: 8192
max_bomb_segments: 6
I'll try on my laptop.
Reagards
Gaetano Mendola
---(end of broadcast)---
one change these values
on your machine!
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Dagoberto wrote:
can somebody tell me how can I get old data from a recently damaged table?
What does mean damaged?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
s.
Empty string and NULL are two different thinks.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message ca
Mirek Rusin wrote:
...what is the best way to force duplicated unique
or primary key'ed row inserts not to raise errors?
Doesn't make sense, am I missing the point ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don'
nch a new satellite using
ariane V rockets ( http://www.satexpo.it/en/news-new.php/1?c=6531 )
this mean more users and more stress for our Postgres installation :-)
http://www.arianespace.com/site/news/news_sub_missionupdate_index.html
some pictures here:
http://66.33.199.225/image_library
1 - 100 of 102 matches
Mail list logo
