Project: Postgres fortunes

Killing the process running VACUUM should work.

regards, tom lane

Just replying to myself ... There is a post where Tom Lane says that it's safe to kill vacuum ... so that's what I did but didn't solve the problem, so vacuum was also just waiting (like the process says).

Anyway, it's my last day in the office, it's 18:00 hs, it's time to go to the bar and not try to solve the last minute problems, right?

Posted by Bruno Mattarollo

As Teodor already pointed there is no non-ambiguous solution, or at least, we don't know it.

Oleg

>>> > Jim C. Nasby wrote:

>>> > Something else to consider is that there's a number of options open to

>>> > you for getting commercial PostgreSQL support should you want it. AFAIK

>>> > you're pretty much limited to Sybase or MySQL when it comes to support

>>> > for their products. Plus the support on these mailing lists is

>>> > absulutely top-notch.


>> Bruce Momjian wrote:

>> But the spelling isn't.   :-)   {Couldn't resist.}

Befour scool i culd not speel enjuneer, now I are one!

-- Jim C. Nasby, Sr. Engineering Consultant

[ excuse me while I retrieve my eyebrows from the back side of my head ]

regards, tom lane

...it may produce unpredictable results for searching, example from head (sorry, russian):

horosho - good ('sh' in russian is one character)

herovo - bad ( slang )

horovo - where is mistype? second character or 5-th? If we correct this to one or both variants, user will get 'bad' for searching query 'good'...

--Teodor Sigaev

> Hi guy,
> Where I con download Postgres 8.2 from ?

> Regards
> Milen

>> It does not yet exist. When it is released you will be able to download
>> it from www.postgresql.org. That is some months away.

>>> I would have just said "We don't know.  If you can figure it out, let us
>>> know what's in 8.2, it will save us a lot of arguing."

>>> --
>>> --Josh

>>> Josh Berkus
>>> PostgreSQL @ Sun
>>> San Francisco

I'm actually in a not dissimiliar position here- I was seeing the

performance of Postgres going to an EMC Raid over iSCSI running at about

1/2 the speed of a lesser machine hitting a local SATA drive. That was,

until I noticed that the SATA drive Postgres installation had fsync

turned off, and the EMC version had fsync turned on. Turning fsync on

on the SATA drive dropped it's performance to being about 1/4th that of EMC.

Moral of the story: make sure you're comparing apples to apples.

Brian

Sorry folks, my fault ... hit the 'accept' button too fast :(

On Sat, 17 Jun 2006, Wilbur wrote:

> Hi there lovely,
> I was asearching the net few days ago. I am new to this thing.
> and saw your profible. I decided to email you cause I found
> you attractive. I maight come down to youra city in fewb weeks.
> Let me know if we can meet each other in person.
> I am attractive girl. I am surea you won't regret it.
> Reply to my personal email at sj@mailforfreedom.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
---

Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)

there are countless results for "X sucks" on $your_favorite_search_engine

...

I am relatively technology-agnostic ... I don't run Windows as a server, and I don't care to. My technology agnosticism stops at inadequate systems.

Jason McManus

> We have customers with Rdb version 4.x (around 15 years old, IIRC) and
> RMS and VSAM formats from the 1980s.

Wow, that *is* ancient.  Rdb 4.2 was 1993, though.  "Only" 13 years.

Snicker.

From: Merlin Moncure <bla-bla@example.com>

To: PGSQL Performance <pgsql-performance at postgresql.org>

Date: Jul 6, 2006 9:53 PM

Subject: [PERFORM] victory!

with all these unsubscribe requests, we can only extrapolate that the

server has no serious performance issues left to solve. good work!

:-)

merlin

I think that in twenty years, I think most of us will be more worried about our retirement than

the long terms data conserns of the companies we will no longer be working for. :-D

> > Присылаю тебе то, что успел натворить, в аттаче (см intarray патченный и
> > stats.php).
> Спасибо, попробую поизучать. Правда, могу и отложить на неопределённое
> время, потому как с первого июля я трижды папулька и свободного времени
> как-то сразу поуменьшилось :-)

Поздравления в кубе ;)

And, as mentioned by Bruce Momjian during his keynote, thanks for

making a great database product that allows so many of us to pay the

bills!

Adem HUR <ademhur@dzhimeyl.com> to pgsql-general:

Hi,

I am sory for my bad English :)

Thanks ...

I'm stupid :-(

--

Best regards,

Nikolay

If a person does not use PostgreSQL because of

our name, then he/she may surely drop, I don't care.

--

Devrim GUNDUZ

The family is more important than PostgreSQL. Having fun with the

family indeed gives energy to someone to work. So, go family fun!

Best Regards,

Carlo Florendo

Astra Philippines Inc.

www.astra.ph

Better plans for this specific example, worse plans for other cases.

Life is not that simple.

regards, tom lane

Thats all for now. It's not a minor fixup and nobody had time to fix

that for 8.2 since other fish were bigger.

Oops. The code I originally posted was wrong. Here's a better one.

> When one of the biggest tables has all lines updated for example, it takes

> at about 30 minutes for processing. If we drop all indexes (21) and let only

> the primary index the same update takes 2 minutes.

21 indexes??

regards, tom lane

A standard btree index is just going to suck for these types of queries

regards, tom lane

RAC is much better than Oracle Parallel Server (OPS) which

had such a (deservedly) bad reputation they had to change the name.

--

Simon Riggs

EnterpriseDB http://www.enterprisedb.com

If you have a problem and try to solve it with XML, then you have two problems.

Harald Fuchs

> Here is a (small) patch to give the ability to pg_dump to export only the
> functions (or only one), very useful when you often develop with psql
> (postgresql.8.2.3)

And the patch is so small, it is invisible (missing).  ;-)

Bruce Momjian, Enterprise DB

I just replaced a million dollar SAN

with a split array/controller enviroment that cost 10% of the cost and

the multiple controller solution is kicking its butt

Joshua D. Drake

> I'm currently dealing with performance issues of postgres and looking
> for some advice.

> Postgres: 7.0.2

Stop right there.  You have *no* business asking for help on an
installation you have not updated in more than six years.

                       regards, tom lane

> What I keep wondering: Isn't there substantial risk involved?

Sure, there's risk.  There's risk in using Slony, too (if you
accidentally issue DDL under Slony without using EXECUTE SCRIPT, you
can find yourself having a rather bad day).

>>> Call me elitist, but I've used OpenVMS for so long that if it's not
>>> a VMS-style shared-disk cluster, it's a false usage of the word.
>>
>> Okay, you're an elitist...

> People still use OpenVMS? ... elitist isn't the word I would choose ;)

Dinosaurist?

The simplification Heikki suggests would save a grand total of 9 lines of C code, two of which are braces.

The following bug has been logged online:

Bug reference: 3396

Logged by: Sergey Burladyan

Email address: eshkinkot __ at __ gmail.com

PostgreSQL version: 8.1.9

Operating system: CentOS release 5 (Final)

Description: strange error report for 'create domain ... default null'

Fellow Postgressors,

...